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'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
Solved! Go to Solution.
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]
@clarkpaul , Can you explain the formula?
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.
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 |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |