Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
smitpau
Helper I
Helper I

DATESINPERIOD Use Max and Filter out Forecast dates

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
2 REPLIES 2
v-yuaj-msft
Community Support
Community Support

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
Helper I
Helper I

Trying something like this but it doesn't work.

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.