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...
Need Help
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.