How to Calculate Year over Year Growth % in Power BI
Рет қаралды 19,938
Күн бұрын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/...
@anilsuvvada7302 28 күн бұрын
Clean n clear👌
@joshuaemmanuel4837 3 ай бұрын
Thank you sooooooo much for this great information ❤🎉
@neroonose4585 3 ай бұрын
Thank you.
@rakeshchaudhary1110 6 ай бұрын
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 5 ай бұрын
Is it possible to remove the 2017 year using a filter? will this impact all the other calculations?
@evangelinevincia1423 10 ай бұрын
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 %
@prerna99 5 ай бұрын
Sir if i have only the year column but not the date column,how the measure calculate is done
Data Science Tutorials
Рет қаралды 6 М.
Kwaku The Analyst
Рет қаралды 158
YOY Comparison Dashboard in Power BI With Dax | Power BI Project from Scratch | Learn Data Analytics
Learn Data Analytics
Рет қаралды 324