Calculate Standard deviation for each period column in matrix table

[Anonymous]

Hi Experts

See attached sample data in the form of a matrix table i want to calculate the Std.dev for each period Month 0, Month 1, Month 2 and show the result in a standard card visual below each column.

Totally stuck.

https://www.dropbox.com/s/0bdlo5sjw9soi7w/FADSampleData%20%282%29.pbix?dl=0 

[Fowmy]

@Anonymous 

You can create the following  calculation and set the month filter in the card visual filter as follows

STD Dev Month = STDEV.S(Llo_FAD_Data[Result])

[Anonymous]

Alternative - could we get the Stand dev of a measure in Power BI - Assume my measure was [Month 0.]

[Anonymous]

Hi Fowmy, Its close but not right i need to take into consideration the Year_month period. Apologies i totally forgot to mention this....

[Fowmy · Accepted solution]

@Anonymous 

You can drag and drop the YearMonth filed to the Visual filter of the card and set the filter

[Anonymous]

Hi Fowny
this is the real tricky one, https://community.powerbi.com/t5/Desktop/Standard-Deviation-of-multiple-values-same-dates/m-p/197750...

could you kindly have alook. please

[Fowmy]

@Anonymous 

Can you accept the solution for the following related question if it works for you?

https://community.powerbi.com/t5/Desktop/Tricky-measure-to-add-columns-in-matrix-table/m-p/1977280

[Anonymous]

Morning Fowmy - i just did the solution was prefect 100%. Thank you