Forum Discussion
Solved
Median value calculation
I am calculating the median value for some weekly game sales in the table below: Game Week 1 Week 2 Week 3 Week 4 Week 5 Worms 2 4 6 8 10 The Escapists 3 6 9 12 15 Overcoo...
NickTeam17 - If you unpivot your week columns so that you end up with:
Game,Week,Value
Then you can create a single measure to calculate your median and then you would put Game and Median into a visual together.
NickTeam17 , I think you need to unpivot not transpose
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose: https://yodalearning.com/tutorials/power-query-helps-transposing-data/
then use
https://docs.microsoft.com/en-us/dax/median-function-dax