topic Consolidating data with same dates; calculating standard deviation for process control chart in DAX Commands and Tips

Consolidating data with same dates; calculating standard deviation for process control chart

Marcus2 — Wed, 27 Mar 2024 03:24:03 GMT

Hi, here is a sample data set for the type of problem that I have.

I would rather group by date, then calculate my standard deviation in DAX.

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.

Jihwan_Kim — Wed, 27 Mar 2024 03:51:14 GMT

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.

Observation total: = SUM( Data[No Observations] )

Standard deviation: = STDEVX.S( ALL('Calendar'[Start of Week]), [Observation total:])