Warehouse daily stock calculation

[ozsoyozan]

Hello there;

I need your help on something.
I want to calculate the daily stock amount by using the daily amount of incoming and outgoing products in logistics warehouses.
What kind of formula should I write?

the calculation is as follows...
.

thank you

have a nice day.

[MattAllington]

DAX is all about filtering. You need to filter the table so it keeps just the records you need. Something like

=calculate(sum(table[in]) - sum(table[out]),filter(all(table),table[date] <=max(table[date])))

[ozsoyozan]

Dear Matt.

Thank you. but which table should I choose in "filter(all (table)"?
I could not fully understand.

[MattAllington]

I can't answer that question - you haven't provided any information about your tables. 

[ozsoyozan]

I have three separate tables. Date, Dispatch and Receiving. The Date table is related with other tables.

[MattAllington · Accepted solution]

I can't read the columns in your dispatch and receding tables, so you will have to swap those out. 

place the Date[Date] column in your visual, then ther measure

=calculate(sum(receiving[in]) - sum(dispatch[out]),filter(all(Date),Date[date] <=max(Date[date])))

[ozsoyozan]

Dear Matt

This formula worked.

Thank you so much. 

Regards