Forum Discussion
Solved
Warehouse daily stock calculation
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 sho...
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])))
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])))
Dear Matt
This formula worked.
Thank you so much.
Regards