Forum Discussion

S_JB's avatar
S_JB
Icon for Resolver III rankResolver III
5 years ago
Solved

Dynamic Field for Quantity

Hi all,   I'm trying to build an inventory report in Power BI to replace a report we have in excel.   The below example shows how the report currently looks in excel:  The inventory column f...
Need Help
  • S_JB's avatar
    S_JB
    5 years ago

    Thanks for your assistance but unfortunately this approach would not work for what I was trying to achieve.

     

    I had to create a measure for week 1 quantity using the historic data and current week, then use this measure as a basis to create a rolling 8 week view.

S_JB's avatar
S_JB
Icon for Resolver III rankResolver III
5 years ago

Thanks for your assistance but unfortunately this approach would not work for what I was trying to achieve.

 

I had to create a measure for week 1 quantity using the historic data and current week, then use this measure as a basis to create a rolling 8 week view.