Measure for Actual and forecast in Months !!

[anjanikumar]

Want meaure for below requirement.

Actual(Past and Current months) and forecast (for feature months) and year also needed in this measure.Please look into below image for clear understand and help me asap.

Thanks In Advance.

[amitchandak]

@anjanikumar, not very clear,

but measure like

calculate([Actual] ,filter('Date', Date[Date] <= eomonth(today(),-1)) + calculate([Target] ,filter('Date', Date[Date] >  eomonth(today(),-1))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[anjanikumar]

Hi Amit,

This is my requirement.

"ACTUAL" OR FORECAST Amount, based on the selection of the month (i.e. if user selects Future months ( March, April, may etc. of 2022) new measure should display Forecast amount (FCST's) in case user selects past months ( Jan ,Feb, in 2022) then the new measure should display ACTUAL amount.

Actual(Past ) and forecast (Current and Feature months).

I want dynamic Measure for above requirement.

Thanks In Advance.