How to compare the difference of the total sales for the years as shown in the table 2013,2017,2021?

[Krist1]

I want to create a card that shows the difference between 2021 and 2017 for example. There are no inbetween years

[komald · Accepted solution]

hi @Krist1 

you can create measure 
sale 2013= calculate(sum(sale), year=2013)
sale 2017= calculate(sum(sale), year=2017)
sale 2021= calculate(sum(sale), year=2021)

after this for comparison , write  measure
compare 2013-2017= sale 2017-sale 2013.
compare 2017-2021= sale 2017-sale 2021
and these measure u can show on cards

[Krist1]

Thank you so much