Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Paulo Vitor Fonseca]

I would like to create a new table to compare the “on time delivery” performance of suppliers, using a database of purchase orders, and another database of goods received, and the PO number & Line to match these information.

My idea is to have a new table with the following data

PO Number
Scheduled Delivery Date
Delivery Date
OTD ok? Conditional = Yes/No

Then, I can measure the % of orders delivered on time.

Someone can help me?

——————————
Paulo Vitor Fonseca

——————————

[Cekou C.]

Hi Paulo,

You can achieve this in a couple of ways :

1) Power Query: Merge Queries (Join kind: Left Outer Join) 
Check this blog for more information

2) Using a mix of ADDCOLUMNS and INTERSECT functions in DAX

INTERSECT returns an entire table or a table with one or more columns. A table that contains all the rows in LeftTable that are also in RightTable.
More about INTERSECT here.

Regards,

——————————
Cekou C.
Accounting Supervisor & PBI Enthusiast
——————————
——————————————-

[Christopher Schnaars]

Hi, Paulo:

You should be able to do this without creating a new table, if the relationships in your report link purchase orders and goods received by PO Number. In that case, you could do a simple count of orders where delivery date <= due date and divide that by total orders.

Good luck!

——————————
Christopher Schnaars
Laboratory Testing Inc.
Hatfield, Pennsylvania
——————————
——————————————-