Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |