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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Date segment that filters between day, month without the year

Hello, 

 

I created a table which compares the turnover bteween the current year and the previous year (years defined dynamically using DAX formulas). However, I cannot filter the period between two dates defined by a day and a month only, without taking the year into account.

 

Example: If I want to compare the turnover for year Y and Y-1 between January 3 and February 5 or between January 10 and February 2, how could I do it ?

 

I would like exactly the same segment as below but without the year (you'll also find the DAX formula I used to show dynamically the turnover of the current year): 

 

Segment_date.PNG

 

Thank you very much !

1 REPLY 1
lbendlin
Super User
Super User

You must take the year into account. You also need to have a proper Dates table, otherwise the time intelligence functions like SAMEPERIODLASTYEAR  will not work reliably.

 

Note that your sample date range already straddles multiple years.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI 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.

Top Solution Authors