Forum Discussion
Warehouse daily stock calculation
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])))
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])))
Dear Matt.
Thank you. but which table should I choose in "filter(all (table)"?
I could not fully understand.
I can't answer that question - you haven't provided any information about your tables.
I have three separate tables. Date, Dispatch and Receiving. The Date table is related with other tables.
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])))