Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need a way to find when an Item running Inventory On Hand QTY first goes negative and display its Due_date.. Example see screen shot where I have Running Inventory totals per Orders. I have a Due_Date of 6/16/2017 when I will have Negative -546 Inventory. I need a way to pick out that date of 6/16/2017 based on that first negative inventory so I can display that in my other table. Can anyone help me figure this out?
Solved! Go to Solution.
Hi @Grunstra,
I thought your resource table in same table, I understand now. Please create a measure using the formula, then add it to your table report.
New Due-Date = MINX(FILTER('OrdersOpen-All','OrdersOpen-All'[Net Inv RT]<0),'OrdersOpen-All'[due_date])
Best Regards,
Angelia
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |