How to Calculate Year over Year Growth % in Power BI
Power BI Tutorial on how to calculate year over year growth % using DAX. This is helpful whether you are improving or declining on a year basis.
We can achieve this using calculate function, dateadd function and divide function.
Dataset link - tinyurl.com/yd65vnf3
For advance dashboard training or consulting, contact - abhishek.agarrwal@gmail.com
Google sheet - docs.google.com/spreadsheets/...
Пікірлер: 8
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
Is it possible to remove the 2017 year using a filter? will this impact all the other calculations?
Clean n clear👌
Thank you sooooooo much for this great information ❤🎉
Thank you.
Hi sir then what is the dax function to find growth over a four year period
@RVideoTutorials
10 ай бұрын
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 %
Sir if i have only the year column but not the date column,how the measure calculate is done