Forum Discussion
Dynamic Weighted Average
I am trying to get the Average Price per month similar to the following. The average needs to change based upon the selection of the Location and Model slicers. Ultimately I need to be able to graph ...
v-juanli-msftI have updated this post becuase what I thought didn't work in the solution seems to work fine. However, the key is that I am going to want to be able to put this in a chart and graph by month with a totla price per month...not by model. When I select multiple months this does not seem to work.
Hi admiralman
put this in a chart and graph by month with a totla price per month...not by model
Does this chart meet your goals?
When I select multiple months this does not seem to work.
What do you want to show when you select multiple months?
Best Regards
Maggie