Forum Discussion
Average Standard deviation calculated per month
Hi I want to calculate a montly standard deviation I want to calculate the standard devation in DAX from my fact table but not the SD per row but totalled per month. My data looks like this ...
some_bih
Community Champion
Community ChampionHi Anonymous try measure
STDEVX.P(Sheet29,Sheet29[Sales])
Sheet29 adjust to your table name
Connect date column with Date table and check results. You provided sample of data so it is hard to check if it is ok. I hope this help