Forum Discussion

deepak91g's avatar
deepak91g
Resolver II
8 years ago
Solved

Need Help to Calculate Week on Week Growth Percentage using DAX

Year-Week Profit WoW% 2018-22 500 250% 2018-21 200 67% 2018-20 300 75% 2018-19 400 -   Expected output is WoW%    I have index columns as well and for each year-week c...
Need Help
  • deepak91g's avatar
    deepak91g
    Resolver II
    8 years ago

    This worked.

     

    But I have lots of Slicer/filters such as category, product name. Do you know, how can I make slicer to work with week-on-week measure?

    Thanks for your help

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      deepak91g

      Try using ALLSELECTED in place of ALL in your measure so that slicers work with your formula.

      • deepak91g's avatar
        deepak91g
        Resolver II
        8 years ago

        Fantastic, It worked.

         

        I really appreciate your help in this. Learned new things while solving this problem.