Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ElektroCED
Regular Visitor

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= 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:

 

ElektroCED_0-1634551335721.png

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):

 

ElektroCED_1-1634551575301.png

 

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

1 REPLY 1
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.