Inventory Week Over Week

[Anonymous]

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!!

[danextian]

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]

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.