Just an FYI, I dont think any of the values in the date difference in months screenshot are actually correct for example, it says the difference between 28 Jun 2014 and 02 Jul 2014 is 5 months (or 20 days) despite being only 4 days apart. An exemple of date : 2015-08-12T08:14:03.2830000. 07-19-2016 08:05 AM @Anonymous You can create a calculated column. need to do is change the "Duration (Seconds)" part at the top Example: Date1 - Today () Date2 - 08/19/2020. Labels: I can say that this formula finally meets what I have been looking for. I am looking for a way to find the difference between two dates. Any help would be greatly appreciated. Example: Date1 - Today () Date2 - 08/19/2020. Make sure that there should not be any syntax error. Both columns are date columns, do you have any suggestions as to where I may be going wrong please? articles that have demonstrated how to approach this. I tried to use DATEDIFF, but it does not work because Date 2 can have a lower date then date 1. WebIn this video, we are going to see how to compare two time periods or two dates dynamically. below. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Go to Add Column >> Custom Column and add the function. In this article, we have provided many examples for DATEDIFF function in Power BI to calculate: Power BI DATEDIFF in Years Power BI DATEDIFF in Quarter Power BI date DATEDIFF in Months Power BI date Yes, a DAX formula like this will work assuming that both of your columns are actually Date columns: Hi@Greg_DecklerI appreciate this post is super old now but I have followed your above suggestion as so -(#"Psych data"[Date received] - #"Psych data"[Date sent])*1 - however receive the following error on all of my entries -Expression.Error: A cyclic reference was encountered during evaluation. This measure will do it for that case, might need some testing for other use cases: Note, for this measure, I created a Date1=TODAY() measure and a Date2=DATE(2020,8,19) measure. Can I compare two custom time periods letting the user choose those periods with a slicer, both in terms of start and duration?
power bi difference between two dates
25
set