Forum Discussion

dantheram's avatar
dantheram
Helper II
3 years ago
Solved

Moving Average - not date based

hi all   i'm really struggling to understand how to compile what should be a very simple MAA. The issue is that i do not use date, i use period numbers; 1 to 13, as below -     all i want ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    dantheram 

    Create a fiscal year period column in both tables the use it in the code. It is also advised to use this column to create the relationship. 
    Fiscal YearPeriod =
    VALUE ( SUBSTITUTE ( 'SAFs Actuals'[Fiscal Year], "/", "" ) ) * 100 + 'SAFs Actuals'[Period]

tamerj1's avatar
tamerj1
Community Champion
3 years ago

dantheram 

Create a fiscal year period column in both tables the use it in the code. It is also advised to use this column to create the relationship. 
Fiscal YearPeriod =
VALUE ( SUBSTITUTE ( 'SAFs Actuals'[Fiscal Year], "/", "" ) ) * 100 + 'SAFs Actuals'[Period]

dantheram's avatar
dantheram
Helper II
3 years ago

you sir are a hero 🙂

 

thanks so much!