Forum Discussion

LouisB's avatar
LouisB
Frequent Visitor
8 years ago
Solved

Creating a Graph of Columns Average

Hello everyone,   I am a new user and I am stuck after few hours... And impossible to find a solution on the forum!   I have a table with different Columns: January, February, March etc.. and th...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi LouisB,

     

    Thanks for your deatils data sample, but is only the month columns useful?

     

    After unpivot your data model, you will get the Month column and another Value column.

     

    Is that the value column the electricity consumption per month?

     

    If you want to calculate the average, you could use calculate(average([value])).

     

    If you still need help, could you share your desired average value so that I can know what value you want to get?

     

    Best Regards,

    Cherry

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

You need to unpivot your month columns in your query. Then you can put that column in your x-axis.