Standard Deviation in Power BI | How to create measures for SD, Mean and Upper/Lower Limits
33.2 هزار بار بازدید -
4 سال پیش
-
In this video you will
In this video you will find the steps to create measures for Standard Deviation, Mean and Upper/Lower limits of the deviation.
With this method the SD calculation can be applied to the filtered data you have in your dashboard. So if you have a slicer in your dashboard, the SD will be only calculated to the data filtered by it.
This measure can then be entered into the BI dashboard to view in your charts and tables, displaying the elements that fall in or out of SD range.
Very easy to do, just have to follow the formula calculation shown in the video.
This will allow you to use Standard Deviation as an analysis tool to detect outliers in a selected population.
If you have any comments, questions, or requests for another video feel free to comment below or drop me a message on Twitter @robertodono!
With this method the SD calculation can be applied to the filtered data you have in your dashboard. So if you have a slicer in your dashboard, the SD will be only calculated to the data filtered by it.
This measure can then be entered into the BI dashboard to view in your charts and tables, displaying the elements that fall in or out of SD range.
Very easy to do, just have to follow the formula calculation shown in the video.
This will allow you to use Standard Deviation as an analysis tool to detect outliers in a selected population.
If you have any comments, questions, or requests for another video feel free to comment below or drop me a message on Twitter @robertodono!
4 سال پیش
در تاریخ 1399/03/19 منتشر شده
است.
33,279
بـار بازدید شده