No video
How to Calculate Week over Week Growth % in Power BI
Рет қаралды 4,198
Күн бұрынPower BI Tutorial on how to calculate week over week growth % using DAX. This is helpful whether you are improving or declining on a weekly basis.
We can achieve this using weeknum, calculate function and divide function.
Dataset link - tinyurl.com/yd...
For advance dashboard training or consulting, contact - abhishek.agarrwal@gmail.com
Google sheet - docs.google.co...
@prabakaran3000 5 ай бұрын
Omg... This is what i was looking... Thank you si much !!!
@RVideoTutorials 5 ай бұрын
You're welcome!
@prabakaran3000 5 ай бұрын
@@RVideoTutorials I need one more help as well. In my report, I have a trend line for sales (Cat 1 , 2 3 respectively) and have cards on top which will show only last week and this week's sales. When I select category 1 trend line should show for last 6 weeks and card data should have only last week and this week data. If I filter to last month even the trend line should show all the feb wk 1, 2, 3,4 .....however in card data should have only this week data alone (Static period. Based on data. How could I proceed ?
@klaraboudova3336 3 ай бұрын
How can I make this work, if I am trying to use measures rather than Count of order ID. This is currently returning as error :(
@saichandu5965 Жыл бұрын
Am looking for this great...rather adding week number can we show as week 1 and week 2 for quarterly wise
@karthikrajag6796 4 ай бұрын
in the week 1st will it bring last week which is 52 nd week of last year sales
@aollesire 4 ай бұрын
How do you deal with week 1. Also I get Infinity and NaN value. Is there a way to deal with that please
Data Science Tutorials
Рет қаралды 26 М.
Adam Finer - Learn BI Online
Рет қаралды 95 М.
WhatTheFactBI
Рет қаралды 4,2 М.
Corporate Skiller
Рет қаралды 13 М.