topic Re: % Average Quarter to Date starting from the beginning each quarter in DAX Commands and Tips

% Average Quarter to Date starting from the beginning each quarter

rmeng — Thu, 29 Apr 2021 10:18:29 GMT

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?

Re: % Average Quarter to Date starting from the beginning each quarter

amitchandak — Thu, 29 Apr 2021 10:07:52 GMT

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

Re: % Average Quarter to Date starting from the beginning each quarter

rmeng — Thu, 29 Apr 2021 10:34:28 GMT

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

Re: % Average Quarter to Date starting from the beginning each quarter

amitchandak — Thu, 29 Apr 2021 10:39:56 GMT

rmeng , Try like

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