Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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):
Thank you very much !
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!