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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
PrivateAnalytic
Helper IV
Helper IV

DAX Formula to remove dates from before the previous year...

Good morning all!

 

I am reaching out to figure out the perfect DAX formula to help filter out dates from more than 365 days ago.

 

I was able to filter out days past today's by using the following formula 

Less than Today =
IF('DateDim'[Date] < TODAY(), "Yes", "No")
 
However the report I am working with only wants values from the last year. Is there a formula I can use to filter out dates from my slicer from the last 365 days?
1 ACCEPTED SOLUTION
PrivateAnalytic
Helper IV
Helper IV

I am also completely forgetting about applying a filter to display dates only within the last 365 days. So this is fixed

View solution in original post

1 REPLY 1
PrivateAnalytic
Helper IV
Helper IV

I am also completely forgetting about applying a filter to display dates only within the last 365 days. So this is fixed

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (27)