% Average Quarter to Date starting from the beginning each quarter

[rmeng]

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?

[amitchandak]

@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

[rmeng]

Thanks for this it works for half of my problem, but (0,29+0,36)/2 should be 0,33, right?

[amitchandak · Accepted solution]

@rmeng , Try like

QTD = CALCULATE(AverageX(values('Date'[Month Year]),[% of KEMS]),DATESQTD(('Date'[Date])))