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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |