How to get forecast (Feb 21+4) based on the figures up to Feb 21

DAX DAX Calculations
1

Hi Team,
I just want to add a measure for (8+4) forecast which is YTD Feb 21 /8*12.

  • I want the measure not related to the month selected in date table.
  • I also want the measure related to the month selected in date table, which is if I select Mar 21, it should calculate YTD Mar 21/9*12 etc.

Please let me know how to get it first with my masked data.
I will then raise another issue.

MaskedDataBudgetQ.pbix (1.2 MB)

Thank you.

Regards,
Aye

2

Hi @ammu,

Created a dynamic measure for you, like this:

YTD FC Dynamic = 
DIVIDE(
    CALCULATE( [Total Actuals] , 
        FILTER( ALL( DateTable ),
            DateTable[FY] = MAX( DateTable[FY] ) &&
            DateTable[FP] <= MAX( DateTable[FP] )
        )
    ),  MAX( DateTable[FP] )
)   * 12

As for your first request, I think you can can create that using this method - just one thing to point out, you will have to protect that calculation in situations where you don’t have Actuals up to Feb

I hope this is helpful.

1 Like
3

Many thanks @Melissa ,
The measure you provided works for both of my requests.
For 8+4 or 9+3, once I got the figure, I can get it or even I can make it fix one with your measure.
Regards,
Aye

1 Like