Problems with Time Comparison

[ElektroCED]

Hello everyone, I'm having a problem with time comparisons using the following formulas (indicated by a forum user):

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

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

Comparison= DIVIDE(YTDmeasure-PYTDmeasure, PYTDmeasure)

(Obviously I insert the values ​​of my table and I also added a comparison between this year and two years ago)

In general they work very well, but in some cases (like the one below) they report incorrect values:

CY = Current Year; PY = Previous Year; 2PY = comparison with two years ago; YTD = Year to Date

The following values, for example, are correct (I report them in order to have a further feedback):

N.b: all comparisons work up to today's date.

Thanks a lot to those who want to try to solve the problem and have a good day.

Gabriele

[amitchandak]

@ElektroCED ,

Please use date table, Which is very important for time intelligence. Join date of you table with date of date table. Date in table should not have time in it.

YTDmeasure= TOTALYTD(SUM(view_PBI_ORD_CLI[IMPORTO_PAG_V1]), 'Date'[Dates])

PYTDmeasure= TOTALYTD(SUM(view_PBI_ORD_CLI[IMPORTO_PAG_V1]),dateadd( 'Date'[Dates],-1, year))

refer

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA