Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I know the question has been asked before, but I cant get it to work. I have two tables with a many to many relationship. Its delivery data for warehouses, and there are "expected" delivery dates and "actual delivery dates.
The "actual delivery" dates are captured in a table named "101_data". The "expected delivery" days are residing in a table named "PO_Data".
My objective is to determine whether a supplier delivers before or after the "expected delivery" dates. So the result of the calculation would be any negative value would indicate the amount of days delivered early. Positive values would indicate the amount of days delivered late.
I have run a pilot in excel where I substract the two dates from eachother which poduces the desired result.
What would the calculation look like as the two colums resides in different tables as indicated above.
Thanks, Jan
Solved! Go to Solution.
Fixed issue by doing a merge between the two data sets.
Fixed issue by doing a merge between the two data sets.
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |