Forum Discussion
Daily change
Hi I have this data set which will be refreshed, and would like to add measure to auto calculate the latest daily changes
Date Turnover
1/1/2016 555
1/2/2016 333
1/3/2016 666
1/6/2016 777
In the above my measure will show 111 (777-666).
I dont think I am able to use previousday() in dax
Please help me crack this problem,
Hello Anonymous
If you're still using daily data, you could use this :
Latest Change = CALCULATE(sum(Turnover[Turnover]);LASTDATE(Turnover[Date])) - CALCULATE(SUM(Turnover[Turnover]);PREVIOUSDAY(LASTDATE(Turnover[Date])))
When nothing is selected, the data represente the daily change for the lastDate, without its previous date (777-666):
When you selec another date (e.g :January 3rd), you've got the daily change between this date and its previous (666 - 333)
Let me know if that fit what you wanted.
Sébastien
2 Replies
Hello Anonymous
If you're still using daily data, you could use this :
Latest Change = CALCULATE(sum(Turnover[Turnover]);LASTDATE(Turnover[Date])) - CALCULATE(SUM(Turnover[Turnover]);PREVIOUSDAY(LASTDATE(Turnover[Date])))
When nothing is selected, the data represente the daily change for the lastDate, without its previous date (777-666):
When you selec another date (e.g :January 3rd), you've got the daily change between this date and its previous (666 - 333)
Let me know if that fit what you wanted.
Sébastien