Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, here is a sample data set for the type of problem that I have.
Date | No Observations |
1/1/2024 | 3 |
1/1/2024 | 5 |
1/8/2024 | 2 |
1/8/2024 | 3 |
1/15/2024 | 4 |
1/15/2024 | 6 |
I would rather group by date, then calculate my standard deviation in DAX.
Date | No Observations |
1/1/2024 | 8 |
1/8/2024 | 5 |
1/15/2024 | 10 |
Using Excel Std Dev = 2.52
How can I group dates and then find standard deviation in DAX? I would like weekly observations on my Process Control Chart.
Solved! Go to Solution.
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
If you are analyzing by week, I suggest having Calendar Dimension table something like below.
Please check the below picture and the attached pbix file.
STDEVX.S function (DAX) - DAX | Microsoft Learn
Observation total: =
SUM( Data[No Observations] )
Standard deviation: =
STDEVX.S( ALL('Calendar'[Start of Week]), [Observation total:])
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
If you are analyzing by week, I suggest having Calendar Dimension table something like below.
Please check the below picture and the attached pbix file.
STDEVX.S function (DAX) - DAX | Microsoft Learn
Observation total: =
SUM( Data[No Observations] )
Standard deviation: =
STDEVX.S( ALL('Calendar'[Start of Week]), [Observation total:])
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
53 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
114 | |
44 | |
44 | |
28 | |
22 |