Forum Discussion
Calculate the difference in values between previous dates
Hi Greg_Deckler ,
Many thanks for your assistance!
I have now figured it out using the following;
Weekly Difference =Var _selecteddate = VALUES('Date Friday Only'[Date])var _maxdate = MAXX(_selecteddate, 'Date Friday Only'[Date])var _value2 = CALCULATE([Eng FullTime], 'Date Friday Only'[Date] = _maxdate)var _value3 = CALCULATE([Eng FullTime], 'Date Friday Only'[Date] = _maxdate -7)Return_value2 - _value3_value3 has -7 because the dates occur every 7 days, thus returns the date for the previous weekThanks
Uka 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
Hello Greg_Deckler ,
The solution did not work for me as I got a wired result as below;
Below is the code that I used;
Uka Post your sample data as text/table and I'll take a look.
Hi Greg_Deckler ,
Many thanks for your assistance!
I have now figured it out using the following;
Weekly Difference =Var _selecteddate = VALUES('Date Friday Only'[Date])var _maxdate = MAXX(_selecteddate, 'Date Friday Only'[Date])var _value2 = CALCULATE([Eng FullTime], 'Date Friday Only'[Date] = _maxdate)var _value3 = CALCULATE([Eng FullTime], 'Date Friday Only'[Date] = _maxdate -7)Return_value2 - _value3_value3 has -7 because the dates occur every 7 days, thus returns the date for the previous weekThanksUka That works!