How to Calculate Year over Year Growth % in Power BI

[@reteshp1170]

Hi There
Thank you for sharing this video. I am looking to create a similar report but I need to display data in a tabular format where all the months will be listed as a very first column then last year then current year and than % change. I also want to allow user to select year as a filter and show actual previous year as header and actual current year dynamic. Can you please guide me on this?

[@joshuaemmanuel4837]

Thank you sooooooo much for this great information ❤🎉

[@rakeshchaudhary1110]

Thank you for sharing the knowledge but hear is some scenario if i want to select a date like 10 nov or any date of month but when I am using the same dax it's giving me all sales of privious year.
And in mtd scenario also

[@LW-ty3vt]

Is it possible to remove the 2017 year using a filter? will this impact all the other calculations?

[@evangelinevincia1423]

Hi sir then what is the dax function to find growth over a four year period

[@RVideoTutorials]

Step 1 - find the 4 year old value using calculate and datediff
Step 2 - find the current value
Step 3- use divide function or relevant growth call to get the growth %

[@anilsuvvada7302]

Clean n clear👌

[@prerna99]

Sir if i have only the year column but not the date column,how the measure calculate is done

[@neroonose4585]

Thank you.

[@mrbartuss1]

Look at the total...