Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rmeng
Helper II
Helper II

% Average Quarter to Date starting from the beginning each quarter

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.

rmeng_0-1619689646400.png

rmeng_0-1619691496938.png

 

Do you have a measure for this?

1 ACCEPTED SOLUTION

@rmeng , Try like

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

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@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_0-1619692357505.png

 

@rmeng , Try like

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors