Calculating stock level value from last month - new demand

[Jakob_PBI]

Hi

I need help to calculate new stock level.
I have 3 tables:

1) inbound (incoming new products to the warehouse)

2) demand (how much demand in qty is expected)

3) stock level (current stock level for 1 date)

i need help to calculate the correct new stock level, which mean i need the "result" from last months new stock level and place it into new stock level static, .. or something.. im not sure but i hope the problem is intuitive, i just need to calculate new stock level by using last months calculation in the next month.

Here is PBI file

https://www.dropbox.com/s/4y23cv00z0y8836/samle%20pbi.pbix?dl=0

and here is pictures in case you cant downloade the file:

the green is right, the red is wrong

in case you cant download the file, its very simple, here is the underlying data:

[v-rzhou-msft · Accepted solution]

Hi,

According to your statement, I think you want [new stock level] returns 1840 in Feb 2023.

Try measure as below.

new stock level =
IF (
    ISBLANK ( [demand_qty] ),
    BLANK (),
    CALCULATE (
        [inbound_qty] + [stock level static] - [demand_qty],
        FILTER ( ALL ( _dimdate ), _dimdate[Date] <= MAX ( _dimdate[Date] ) )
    )
)

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.