Forum Discussion

ShaileshKT's avatar
ShaileshKT
Frequent Visitor
1 year ago

12 Month Average

Hi Everyone, I wanted to calculate the average of last 12 month to forecast sales value. I have below table: Here I wanted to refer forecasting average value as actual to calculate next month...
Tips and Tricks
ShaileshKT's avatar
ShaileshKT
Frequent Visitor
1 year ago

Hi danextian,

Is there any way to achieve this using calculated column?

 

Thank You

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Calculated columns still use DAX and you're looking into creating several calculated columns with the later one referencing the results of the previous ones.