Forum Discussion
Get the Date difference between values
JEM_Systems Not sure I quite understand. Can you provide an example of correct output? Seems like everything would be 0 days in your example. This might help:
See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.
The basic pattern is:
Column =
VAR __Current = [Value]
VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])
VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
__Current - __Previous
The output should be the number os days of difference. The date on my example is all 10/03/2023 because all of these orders are from today.
I do not understand your example, what VAR __Current = [Value] is? Greg_Deckler
JEM_Systems That just grabs the row's current value of the Value column and stores it in a variable. Subtracting two dates gives back the number of days since a date is just an integer of the number of days since 12/30/1899. If necessary, you can force it to be a number with a RETURN of this:
(__Current - __Previous) * 1.