Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@Avantika-Thakur Here is a sample of the dataset. Is this what you are asking for?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |