Replace id of multiple columns with the value from a column of another table

[Anonymous]

There are two tables like below.

Left one contains Delivery ID , Week for delivery and its corresponding date of delivery.

Right one contains multiple columns consist of Delivery ID. platformID is the common column among my most tables.

What I want to do:

1) Replace the id in right one with the exact date from left one.

2) Keep the relation between Delivery ID and WeeK . I need Week as a field for filter because there exists duplication of Delivery

The result should be like :

I'am pretty new to Power BI.  And, I do check some similiar questions but I still stuck here.

Any suggestion is appreciated!

[Icey]

Hi @Anonymous ,

Do you have relationships between your tables? Could you share more details with us?

Best Regards,

Icey

[MFelix]

Hi @Anonymous ,

You information is pretty slim can you please see this post regarding How to Get Your Question Answered Quickly (courtesy of @Greg_Deckler) and How to provide sample data in the Power BI Forum (courtesy of @ImkeF).

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.