Forum Discussion
Solved
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 ...
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.
Found solution:
Base = var _2016 = CALCULATE(SUM(Data), Dates[year]= 2016)
return _2016
I 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.