Forum Discussion

rhborders's avatar
rhborders
Icon for Helper I rankHelper I
8 years ago
Solved

Grouped STDEV

Hello,    I am currently working on getting a column to return a grouped STDEV and having trouble finding the correct way to write the formula. My goal is to have the column return the standard dev...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi rhborders,

     

    Please refer to below M code:

    #"Grouped Rows" = Table.Group(#"Changed Type", {"Category"}, {{"New col", each List.StandardDeviation([Value]), type number}})

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi rhborders,

 

Please refer to below M code:

#"Grouped Rows" = Table.Group(#"Changed Type", {"Category"}, {{"New col", each List.StandardDeviation([Value]), type number}})

 

Best regards,

Yuliana Gu

rhborders's avatar
rhborders
Icon for Helper I rankHelper I
8 years ago

Thank you!