Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Pivot dynamically in Power Query

Hi,   I have the following table as input, the table has the number of units sold for 4 products (A,B,C & D), everyday. I have just shown a sample of 14 days here: I want powerBI to display ...
Need Help
Ahmedx's avatar
Ahmedx
Super User
2 years ago

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

 

  • brokencornets's avatar
    brokencornets
    Helper IV
    2 years ago

    Your solution is definitely more elegant than mine, but I think it needs tweaking as this would also bring back W42 of 2022

    • Ahmedx's avatar
      Ahmedx
      Super User
      2 years ago

      I have modified two options, you can download again

      • brokencornets's avatar
        brokencornets
        Helper IV
        2 years ago

        I tried again but when I add extra data in the source for W42 of 2022 it's not filtered out by the Custom1 step