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
mdonawho
Frequent Visitor

How to get an average - I'm just not getting it

I have read several posts and I am not getting it.  I have thee following that I am trying to replicate in PBI.  I have tried everything I can think of and tried to follow the solutions and it's just not happening.  Please help with my frustration.

 

I am trying to get to the monthly average.

 

Monthly Comparison Average.png

4 REPLIES 4
Avantika-Thakur
Solution Supplier
Solution Supplier

@mdonawho  - Can you pls show the current data model that you are using?

@Avantika-Thakur   Here is a sample of the dataset.  Is this what you are asking for?

Screenshot 2023-03-29 042750.png

Avantika-Thakur
Solution Supplier
Solution Supplier

Hi @mdonawho ,
You can try creating the below meaqsures for the required scenarios :

(1) Yearly Average - Average calculated across all the months of a year 
= Calculate(Average(Value),All except(Table, Year))
(2) Monthly Average - Average calculated across all the years of a particular month 
= Calculate(Average(Value),All except(Table, Month))

Hope this helps!

 

Regards,

Avantika Thakur

Thank you for your input but again I am not getting it.  What is the All Except?
MonthlyAverage = Calculate(Average(Value),All except(Table, Month))
I'm sorry but this is like pushing a round plug through a square hole for me.;

 

Thank you for your patience and help

Michael

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.