DATESINPERIOD Use Max and Filter out Forecast dates

[smitpau]

Hi,

I'd like to use code like below, but to filter the max for a calculated column in the calendar which is already created that says "Actuals".

DATESINPERIOD(Calendar[Date],MAX(Calendar[Date]),-12,MONTH)

Any help would be appreciated.

Thanks

[v-yuaj-msft]

Hi @smitpau ,

Can you share some sample data and the expected result to have a clear understanding of your question please? I can do some tests for you.

You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

Best Regards,

Yuna

[smitpau]

Trying something like this but it doesn't work.

max(lookupvalue(('Calendar'[Date]),'Calendar'[Actual/Forecast],"Actual")),-12,MONTH))