Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
97 | |
85 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |