Grouped STDEV

[rhborders]

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

[v-yulgu-msft · Accepted solution]

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]

Thank you!