Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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])))
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |