Comparison of values ​​between different years

[Anonymous]

Hello everyone,

I would need that, making a comparison of a certain value with the previous year, for the current year count the value up to today's date and do the same thing for the year before (if today is 05 August 2021 I would need that the comparison with the previous year is taken until 05 August 2020 and does not take the values ​​of the whole year - I would need a function that does this without having to set the filter every time). In fact, I would need the date to be adaptive, i.e. every day increases / adapts the comparison without having to do it manually

[Tanushree_Kapse · Accepted solution]

Hi @Anonymous ,

YTdmeasure= TOTALYTD(SUM(Table[Total Sales]), Table[Dates])

PYTDmeasure= CALCULATE(YTdmeasure, PARALLELPERIOD(Table[Dates], -12, Months))

Comparison= DIVIDE(YTdmeasure-PYTDmeasure, PYTDmeasure)  ........format this to percentage

I hope this helps!

Mark it as a solution if it answers your que.

Thanks.

[Anonymous]

Thank u so much. It's perfect.

Have a great day