Forum Discussion

Marcus2's avatar
Marcus2
Icon for Helper I rankHelper I
2 years ago
Solved

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

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 ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    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:])

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

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:])