Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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's avatar
Anonymous
Not applicable
10 years ago

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's avatar
Anonymous
Not applicable
10 years ago

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