Forum Discussion
Modifying quick measure YoY%
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'[D...
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.