Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@Anonymous
You can drag and drop the YearMonth filed to the Visual filter of the card and set the filter
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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])
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Alternative - could we get the Stand dev of a measure in Power BI - Assume my measure was [Month 0.]
Hi Fowmy, Its close but not right i need to take into consideration the Year_month period. Apologies i totally forgot to mention this....
@Anonymous
You can drag and drop the YearMonth filed to the Visual filter of the card and set the filter
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Morning Fowmy - i just did the solution was prefect 100%. Thank you
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |