Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Return first date with zero inventory

Hi all,    I need to find the first date our sales location have zero inventory of a product.    I have tried every possible way to calculate this.    So wanted result is this:    I ned...
DAX
Desktop
Need Help
rfigtree's avatar
rfigtree
Resolver III
5 years ago

=calculate(min(table[date]),filter(all(table),table[runninginventory]<=0))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks, but I don't have the runninginventory as a column. I dont understand how to calculate it. If i solve that everything else should fall in place. 

     

    Any suggestions? 

    • rfigtree's avatar
      rfigtree
      Resolver III
      5 years ago

      running=calculate(sum([distributed]) - sum([activated]) - sum([returned]), filter(all(table), [date] <= earlier([date]))

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi, rfigtree 

         

        Thanks but that didn't really solve my problem. 

        First distribution for 7 nights kiosk is on the 1.10.2020. on 14.10.2020 inventory should be 6, instead I get the first product activation. So the first date formula returns the dates for every activation, not when inventory is <= 0. 

         

        Any suggetions? I really need to solve this puzzle 🙂

         

        Thank you

        Christer