Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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
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
Thank you Sebastien, this is the second time you'd helped me. Thank you again.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |