Forum Discussion
Solved
Last 12 months average
Hi, I am trying to calculate average last 12 months debtor days. The step by step calculation is: A. average last 3 months sales B. debtor closing balance C. days in count D. debtor days ...
yonk , I think this type of measure should work
Rolling 12 = calculate(AverageX(Values('Date'[MONTH Year]),[Debtor Days]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))
You can check for number of month to only get it when 12 months are there
yonk , I think this type of measure should work
Rolling 12 = calculate(AverageX(Values('Date'[MONTH Year]),[Debtor Days]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))
You can check for number of month to only get it when 12 months are there
Thank you very much this seems to work!