Forum Discussion

NickTeam17's avatar
NickTeam17
Frequent Visitor
6 years ago
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...
  • Greg_Deckler's avatar
    6 years ago

    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.