Calculate standard deviation from sum of cost per month

[Anonymous]

Hello Everyone,

I am trying to calculate the standard deviation of sum of cost for a specific Id over months.

What I would like in my dashboard is to have a table with IDs as rows and STD value over months.

Here is an example of the data I am having.

Here is the Dax formula i'm trying to use but it seems its calculating the STD Over all costs and its not summing them per month

STD = CALCULATE(STDEV.S(Costs[Cost]), FILTER(Costs, Costs[Date].[Month]))

Can anyone help me solving this problem I am facing,

Thanks !

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

The dates are grouped by the following way. Try below formula:

STD = 
CALCULATE (
    STDEV.S ( Costs[Cost] ),
    FILTER ( ALL ( Costs ), Costs[Date].[Month] = MAX ( Costs[Date].[Month] ) )
)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.