Forum Discussion
Complicated date matching help needed...
Hi delsbg ,
Sorry, because of the example, I thought it was a one-to-one relationship...
Can you share your pbix document? By the way, let me tell you the logic of the two columns New_Due_Date and Action, so as to better solve your problem.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is a pbix file that contains exactly what your original file contained except I've added in multiple orders for the same part number. Doing so returns an error message for your two new columns.
The file is here
I'm not sure I understand your question regarding the logic of the New_Due_Date and Action column. They seem to be working in your example. The only issue is the fact that your model does not support multiple customer orders for the same part. In reality this report needs to make sure we adjust due dates on Purchase Orders so that we have product in house on the day we need it. It should also make sure we don't have it early.