Forum Discussion

yonk's avatar
yonk
Regular Visitor
4 years ago
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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Super User
4 years ago

yonk , if you need sum till month level and then take Average then

 

example

 

Rolling 12 = calculate(AverageX(Values('Date'[MONTH Year]),CALCULATE(sum(Sales[Sales Amount]))),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

 

Rolling Months Formula: https://youtu.be/GS5O4G81fww

Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA