Forum Discussion

MonsterATS's avatar
MonsterATS
Regular Visitor
4 years ago
Solved

Standard Deviation from a Cumulative Measure

I have dozens of locations with different start dates.  For each location I have monthly productivity.  Using a start date and a separate table of 'Months On Production' I can compare locations by mo...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi， MonsterATS ；

    You could create a measure then use STDEVX.P() .

    1.create a CumProduction measure.

    CumProduction =
CALCULATE (
    SUM ( 'Table'[Production] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Location] ),
        [Months Producing] <= MAX ( 'Table'[Months Producing] )
    )
)

    2.calculate stdevx.

    stdevx = STDEVX.P(ALLEXCEPT('Table','Table'[Months Producing]),[CumProduction])

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi， MonsterATS ；

You could create a measure then use STDEVX.P() .

1.create a CumProduction measure.

CumProduction =
CALCULATE (
    SUM ( 'Table'[Production] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Location] ),
        [Months Producing] <= MAX ( 'Table'[Months Producing] )
    )
)

2.calculate stdevx.

stdevx = STDEVX.P(ALLEXCEPT('Table','Table'[Months Producing]),[CumProduction])

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.