Forum Discussion

rhborders's avatar
rhborders
Helper 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 deviation for a group of averages based on this group by:

If any more information is needed please let me know. 

 

Thanks

 

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

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft 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