Forum Discussion

ElektroCED's avatar
ElektroCED
Regular Visitor
4 years ago

Problems with Time Comparison

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= CALCU...
Need Help
ElektroCED's avatar
ElektroCED
Regular Visitor
4 years ago

I used the function that you suggested to me but when i try to filter for a state it goes in error.

Below the real functions I use:

 

IMPORTO_PAG_V1 YTDmeasure = TOTALYTD(SUM(view_PBI_ORD_CLI[IMPORTO_PAG_V1]), view_PBI_ORD_CLI[DATA_DOC])

 

IMPORTO_PAG_V1 PYTDmeasure = CALCULATE([IMPORTO_PAG_V1 YTDmeasure], PARALLELPERIOD(view_PBI_ORD_CLI[DATA_DOC], -12, MONTH))
 
I can't understand why in general they are correct while when I select a filter (for example, the State) it gets confusing
amitchandak's avatar
amitchandak
Super User
4 years ago

ElektroCED , Please use date table, Which is very important for time intelligence

 

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