How to Calculate Week over Week Growth % in Power BI

Поділитися
Вставка
  • Опубліковано 11 вер 2024
  • 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...

КОМЕНТАРІ • 7

  • @prabakaran3000
    @prabakaran3000 6 місяців тому

    Omg... This is what i was looking... Thank you si much !!!

    • @RVideoTutorials
      @RVideoTutorials  5 місяців тому +1

      You're welcome!

    • @prabakaran3000
      @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
    @klaraboudova3336 4 місяці тому

    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
    @saichandu5965 Рік тому

    Am looking for this great...rather adding week number can we show as week 1 and week 2 for quarterly wise

  • @karthikrajag6796
    @karthikrajag6796 4 місяці тому

    in the week 1st will it bring last week which is 52 nd week of last year sales

  • @aollesire
    @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