Forum Discussion
Solved
Power Query Editor: custom column based on another table
Hi, I have two tables with the fields as follow: TransactionTbl: Material, transaction date, quantity, cost, plant, supplier. SupplierTbl: MaterialNbr, Preferred supplier, plant code, contract s...
I found a solution. In the SupplierTbl, I can add rows for dates between start and end dates.
(following instructions I found here: https://natechamberlain.com/2018/08/08/how-to-add-rows-for-dates-between-start-and-end-dates-in-power-bi-date-range-data/)
That way, I can merge by matching MaterialNbr, Plant code, and Date.
I don't have any duplicate in my SupplierTbl. But if you look back at my screenshots, there are two records for Material number 10009090, both with Plant code POBG. Thus, in my TransactionTbl, every time I have a row with Material number 10009090 and Plant code POBG, two rows will be created after merging.
Can you remove the test supplier? Or was this just an example to illustrate the issue?