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.
Hi,
This will be easier to do with DAX as a calculated column. Would you be OK with this approach?
hi Ashish,
for sure. I'd love to see your approach. Thank you!