Hey guys
I have a problem using SAMEPERIODLASTYEAR to calculate the billing variation per month. The current month is not complete but the formula is considering the current month of last year as complete and the variation is wrong
The page has a relative date filter like this year
When I put a filter between dates, for example 01/01/2023 to 09/19/2023, the billing variation is correct
My dCalendar table looks like this -> dCalendar = CALENDAR(DATE(2011,01,01),TODAY())
Measures:
Billing = SUM(SALES[VALUE])
Billing LY = CALCULATE(SALES[VALUE], SAMEPERIODLASTYEAR(dCalendar.[Date]))
Has anyone experienced this?
Hey guys
I broke my brain and found a solution lol
Created a new date table with the full period | calendario= date(2011,01,01),date(2100,12,31)) and connected the sales base after this, connected the old date table (dCalendar) with the new date table (calendario) and I'm using it as an automatic filter For dates
Hey guys
I broke my brain and found a solution lol
Created a new date table with the full period | calendario= date(2011,01,01),date(2100,12,31)) and connected the sales base after this, connected the old date table (dCalendar) with the new date table (calendario) and I'm using it as an automatic filter For dates
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
