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
    7 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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 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

LouisB's avatar
LouisB
Frequent Visitor
7 years ago

Hi v-piga-msft,

first thank you so much for your help.

 

You got it ! The solution was to Unpivot and not just Pivot my table :)

Then Group the rows by Month and setting the average of all the values.

 

Thank you all so much for your help.