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.
I have a simple excel table to show the calculations needed. I don´t know how to calculate a Average (green row) from a previous measure (% of HCP Met).
It´s a Quarter toDate or Year to Date Average and in this case for the next quarter (Qtr2) the value resets and the running total goes on computing the values.
Do you have a measure for this?
Solved! Go to Solution.
@rmeng , Try like
QTD = CALCULATE(AverageX(values('Date'[Month Year]),[% of KEMS]),DATESQTD(('Date'[Date])))
@rmeng ,with help from date table and time intelligence you can try
QTD = CALCULATE([% of KEMS],DATESQTD(('Date'[Date])))
YTD = CALCULATE([% of KEMS],DATESYTD('Date'[Date],"12/31"))
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0
Thanks for this it works for half of my problem, but (0,29+0,36)/2 should be 0,33, right?
@rmeng , Try like
QTD = CALCULATE(AverageX(values('Date'[Month Year]),[% of KEMS]),DATESQTD(('Date'[Date])))
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |