Forum Discussion
Dynamic Comparison from Base date (Not Year)
Hi,
I have two tables, dates and sales.
Dates table = contains dates from 2013-2023.
Sales table = contains per day sales data of 12 products from January 1st, 2016 to-date.
I would like to make all current data comparable to 2016 as base date/year. I want to make base period comparable e.g. if I want to check Feb 2018 data against Feb 2016, or Q2 of 2017 to Q2 of 2016. Any suggestions on how I can make it happen?
I have seen other post https://community.powerbi.com/t5/Desktop/Year-over-base-year-growth/m-p/312339#M138498 but didn't work well.
Any suggestions?
Found solution:
Base = var _2016 = CALCULATE(SUM(Data), Dates[year]= 2016)
return _2016I am able to use the measure with other calculations including % growth. I am also able to slice the data based on dates, months and quarter.
1 Reply
Found solution:
Base = var _2016 = CALCULATE(SUM(Data), Dates[year]= 2016)
return _2016I am able to use the measure with other calculations including % growth. I am also able to slice the data based on dates, months and quarter.