Measure to divide current year by next year month on month

[Anonymous]

Hi Experts

Need a measure to divide the months in the current year 2020 by the same month.for the years 2021.

So Jan 2020 sales 2000 divide Jan 2021 sales 1000 and express as a percentage for all 12 periods.

Want to add measure to a matrix table

[amitchandak · Accepted solution]

@Anonymous , try measure like the example with time intelligence and date table

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

nextyear MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],12,MONTH)))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.