Daily change

[Anonymous]

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,

[Anonymous · Accepted solution]

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

[Anonymous]

Thank you Sebastien, this is the second time you'd helped me. Thank you again.