Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
6 years ago
Solved

Growth Week on Week

Dear Experts, i have a requirement to create week on week growth rate below is how the  table looks Growth should be calculated based (Current week GLobal Ter/Previous Week Global TER)-1 h...
Need Help
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Yeah, that's going to be extra nasty because you have weird text weeks. I would recommend coming up with a sequential number for your weeks and then it is trivial. See these links:

 

This one compares a row with another "previous" row.

See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586

 

And this is a Sequential number for weeks:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231#M116

      • vjnvinod's avatar
        vjnvinod
        Impactful Individual
        6 years ago

        amitchandak 

         

        thanks, its really close

        however My date table should basically start from July to June(Fiscal year for my org) and your logic is based on Calendar year

        can you see if you can change in the pbix i have shared below?

         

        and also in addition to what you have in date coloumn

        i need 1 more coloumns one for "WeekPeriod"

        and logic for weekperiod is

        if my Week start date is 7/1/2019: then it should be P1 Wk1

        if my Week start date is 7/8/2019: then it should be P1 Wk2 and so on til P1 Wk4 (for the month of July)

        and for the month of august, same above logic applies, instead of P1, it will become P2 and combination of weeks

        and this way it should go till June 2020

        This coloumn is needed to connect my source data to the date table

         

        here is my pbix file, i have replicated the date table from the pbix you shared

         

        https://drive.google.com/file/d/1rq0jvs6DeidfLlkmdo04W24RUAVVC1o1/view?usp=sharing

         

         

    • littlemojopuppy's avatar
      littlemojopuppy
      Community Champion
      6 years ago

      To pile on what Greg_Deckler  said, this is very easy to accomplish if you use dates and some basic time intelligence functions.  Is it at all possible to translate P4 Week 1 into dates?  Assuming that P4 refers to Period 4 which could be 4/1 through 4/30 (or whatever they are).  You include the period and week numbers in the date table and this becomes rather simple to accomplish.