I'm having trouble finding the weighted average by month. I have the following data:
The solution I'm trying to get to is the column Weighted Avg.
Any help would be appreciated
So the solution was to build 2 measures:
% of Hist Total = sum('Table'[Hist Value])/sumx(all('Table'),'Table'[Hist Value])
Weighted Avg = sum('Table'[Hist AR Value])*'Table'[% of Hist Total]
So the solution was to build 2 measures:
% of Hist Total = sum('Table'[Hist Value])/sumx(all('Table'),'Table'[Hist Value])
Weighted Avg = sum('Table'[Hist AR Value])*'Table'[% of Hist Total]
I take the percentage of the Machines Sold by month to the total machines sold and multiply that result by the Feature Attach Ratio.
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
