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.
Hi,
I have to calculate the difference with previuous data avaiable, but I dont' have a fix delta time:
am | val | delta |
30/11/2022 | 5000 | 67% |
31/12/2021 | 3000 | 50% |
31/12/2020 | 2000 | 67% |
31/06/2020 | 1200 |
With a defined period (11 moth) no problem
DELTA = (SUM(table[val])-CALCULATE(SUM(table[val]),PARALLELPERIOD(table[am],-11,MONTH)))/CALCULATE(SUM(table[val]),PARALLELPERIOD(table[am],-11,MONTH))
But if the period is not fixed which is the solution?
Solved! Go to Solution.
@Ice_82 , refer if the new offset function can help
Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U
For fun only, a showcase of powerful Excel worksheet formula,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Sorry I simplified the real aggregation, my data are grouped in this way:
am | liv1 | flag | val | delta | |
30/11/2022 | group1 | a | 1000 | 43% | |
b | 1500 | 114% | |||
group2 | a | 1000 | 11% | ||
b | 2000 | 67% | |||
31/12/2021 | group1 | a | 700 | 17% | |
b | 700 | 40% | |||
group2 | a | 900 | 13% | ||
b | 1200 | 20% | |||
30/11/2021 | group1 | a | 600 | ||
b | 500 | ||||
group2 | a | 800 | |||
b | 1000 |
In this situation, how can I modify your code?
Thanks
@Ice_82 , refer if the new offset function can help
Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
21 | |
7 | |
6 | |
5 | |
5 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |