Issue calculating standard deviation for difference Actual and PrevMonth value

[Tairo]

I like to calculate the standard deviation for the difference between actual and previous values. I created measures to calculate the actuel and the valiousof the previous month and for the difference between the two. I wanted to stdev.p formula to calculate the sd for the differences but notices that you can only use columns and not measures.

So I wanted to switch from measures to calculated columns but notices that the values between the two are not the same. Althoug I used the same formula?

Anabody knows how to solve this?

Tairo

[BILASolution · Accepted solution]

Hi @Tairo

Check this pbix...

https://1drv.ms/f/s!AuU-Ye8UGM4Rko0dyKxTaxuA6pAP8A

BILASolution