Forum Discussion
Conditional Measure for specific row across two tables
Dear all, I am looking to include a measure in my report which calculates the difference between inventory and open orders. The values come from different source tables which are connected by mat...
see attached
Thank you so much for this! An added complexity in my data set (I simplified it for the purpose of the post) is that every order also has a loading date, and orders with a higher order number could have an earlier loading date than an order with a lower order number. Is there a way to reflect loading date in your code, so that an order that loads earlier is consuming inventory first? I appreciate the help.