Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I tried to modify the quick measure (Year over year change). Original DAX looks like:
Taxi Out Time, min YoY% =
VAR __PREV_YEAR = CALCULATE(SUM('QAR data'[Taxi Out Time, min]), DATEADD('DATES'[DATE_FULL], -1, YEAR))
RETURN
DIVIDE(SUM('QAR data'[Taxi Out Time, min]) - __PREV_YEAR, __PREV_YEAR)
I decided to make some modification:
Taxi Out Time (sum), min YoY% =
VAR a = SUM('QAR data'[Taxi Out Time, min])
VAR prev_a = CALCULATE(a, SAMEPERIODLASTYEAR(DATES[DATE_FULL]))
RETURN
DIVIDE(a - prev_a, prev_a)
But new formula didn`t work well:
(the first column is a month name in Russian)
Please help to understand, what am I doing wrong?
Variables in DAX are CONSTANTS. Once calculated, they are NEVER re-calculated.
@Anonymous , Make share months are coming from Dates Table
This year = SUM('QAR data'[Taxi Out Time, min])
last Year = CALCULATE([This year], SAMEPERIODLASTYEAR(DATES[DATE_FULL]))
Change % =
DIVIDE([This year] - [last Year], [last Year])
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Hi, @Anonymous , the issue results from use of variable a in your measure; In fact, variables in DAX are NOT THAT VARIABLE as expected!
In DAX, variables are calculated within the scope in which they are written, and then the result of them is stored and used in the rest of the expression.
You might want to refer to an article on this subject for more details.
A straightforward way is to create a measure a = SUM('QAR data'[Taxi Out Time, min]), and you can reference it in another measure.
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! |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |