Dynamic column name based on a column value coming from a different unrelated table

Hi Anonymous - Associating the columns from Table A with the values from Table B, you can do in power Query as below:

Please follow the steps:

On table B:

Do the pivot :and I named it as TableB_Pivoted

On Table A, you can perform Merge query by joining the Table A with TableB_Pivoted use left outer join

Expand all 4 columns , you can see the below image:

Click on Add Column -> Custom Column.
Name the column Column1 - Extract Date and use the following formula

TableB_Pivoted[Column1]{0} 

TableB_Pivoted[Column2]{0}

TableB_Pivoted[Column3]{0}

TableB_Pivoted[Column4]{0}

Repeat this for all columns in Table A (Column2, Column3, Column4).

Perform last few steps:

Do a pivot on Table A with Selecting Column 1 

do it for remaining 3 columns too

I am not able to share pbix file here, not sure how to share it here.

i will add the complete advanced query editor

Please follow the steps you can achieve the same.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!