Forum Discussion
Line and Column Chart - YoY Trend Lines?
Awesome - thank you! Anytime you do division, use the DIVIDE DAX function, you will have better performance. For the YoY% you can utilize the quick measure. In your data pane, go to your measure Total Cost, click the 3 dots, click New quick measure.
Once that selection opens up you can choose the Year-over-year-change option:
And, add your date from the date table to the date well, then click add:
You'll wind up with DAX measure with this for the DAX (assuming your date table is marked as a date table, if it's not then your date portion of the measure will have 'Date'[date].[Date]) :
Total Cost YoY% =IF(ISFILTERED('Date'[date]),ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),VAR __PREV_YEAR = CALCULATE([Total Cost], DATEADD('Date'[date], -1, YEAR))RETURNDIVIDE([Total Cost] - __PREV_YEAR, __PREV_YEAR))
Super UserCan you share your DAX for the YoY measure? Also, I would suggust creating an explicit measure for Cost instead of using the implicit one currently in the visual.
http://powerbiwithme.com/2023/10/25/the-explicit-implicit-measure-edition/
Thank you for the resource! I forgot to change it over to the one I've calculated, so thanks for the reminder on that as well.
These are the 3 DAX functions at play here :Total Cost = SUM('2022 - 2024 Expenses'[Cost])Cost LY = CALCULATE([Total Cost], DATEADD('Calendar'[Date], -1, YEAR))Cost YoY = ((([Total Cost] - [Cost LY]) / [Cost LY]))- audreygerred
Awesome - thank you! Anytime you do division, use the DIVIDE DAX function, you will have better performance. For the YoY% you can utilize the quick measure. In your data pane, go to your measure Total Cost, click the 3 dots, click New quick measure.
Once that selection opens up you can choose the Year-over-year-change option:
And, add your date from the date table to the date well, then click add:
You'll wind up with DAX measure with this for the DAX (assuming your date table is marked as a date table, if it's not then your date portion of the measure will have 'Date'[date].[Date]) :
Total Cost YoY% =IF(ISFILTERED('Date'[date]),ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),VAR __PREV_YEAR = CALCULATE([Total Cost], DATEADD('Date'[date], -1, YEAR))RETURNDIVIDE([Total Cost] - __PREV_YEAR, __PREV_YEAR))That did it! Thank you so much for being so thorough and providing sources. Tremendous help.