Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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  ...
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

if you want the sum of sales for each month alone, try using 

 

SUMX(values([Month-Year]),[sales measure])

 

or

 

CALCULATE(SUM([Amount]),ALLEXCEPT(Table,[Month-Year],[Category]))

 


this will give you sum of sales by month - year use the first if you dont have ctageories an dsub categories and use the second if you have categories and sub categories