Relationship!

Hi Anonymous 

BhaveshPatel points to the right direction.

I make a simple example how to use Power Query to denormalize your tables to achieve the desired output as BhaveshPatel suggested.

1.add a custom column as below in each table

2. rename columns as below in each table

3. append four tables as a new table (note : columns'names should be the same in each table)

4.close&&apply, then you could create calculated columns or measures in Data model/Report view with DAX.

Besides, if using this transform still doesn't work, please show me the structure of "dp list" table, i need to know how "module" relates with the "dates" of "start/ finish plan and actual".

Best Regards

Maggie