Forum Discussion
Weighted Average with calculated weights
Hello again PBI community, thank you for the responses to my last post. I will test and confirm answers on Monday I have quite a good problem to solve. I have 3 tables. The first table con...
The weighted average for category A should be the weights of each item [(6 * 50,000) + (5 * 60,000)] / total days in category (11) = 54,545. The weighted average is not filled in yet in my screen shots because I can't figure out the calculation. The blue fields filled in are what I am able to do so far. Having the days in period respond to the slicer selections is throwing me for a bit of a loop.
Thank you for the clarifying question, and any help from the community would be much appreciated :)
OK, got it. Can you post your current measure/column formulas?