Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Inventory Week Over Week

Hi all,

 

I am trying to calculate week over week inventory - this is what my data currently looks like:

But I need the end inventory to be the starting inventory for the next week like this:

 

Thanks in advance!!

 

 

 

Need Help

2 Replies

  • danextian's avatar
    danextian
    Super User
    2 years ago

    Hi Anonymous ,

     

    Create a separate Dates table (if you don't have one yet) and use the week start from that table in your visuals. Then create this measure.

    Start/Opening inventory =
CALCULATE (
    MAX ( data[ending inventory] ),
    FILTER ( ALL ( datestable ), datestable[week] < MIN ( data[week] ) )
)

    Please refer to attached pbix files for the dates table and sample calculation of opening balances.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi - thanks for the response! I am getting this error:

       

      Not sure if this helps, but my starting, change, and end inventory are all measures not a column. All of my tables are connected by date.