Forum Discussion

ozsoyozan's avatar
ozsoyozan
New Member
5 years ago
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...
Need Help
  • MattAllington's avatar
    MattAllington
    5 years ago

    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's avatar
ozsoyozan
New Member
5 years ago

Dear Matt.

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

MattAllington's avatar
MattAllington
Community Champion
5 years ago

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

  • ozsoyozan's avatar
    ozsoyozan
    New Member
    5 years ago

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

    • MattAllington's avatar
      MattAllington
      Community Champion
      5 years ago

      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's avatar
        ozsoyozan
        New Member
        5 years ago

        Dear Matt

        This formula worked.

        Thank you so much. 

        Regards