Use data from one table as column header in an other

[Anonymous]

Hi,

I have a set of flat filers I've imported into Power BI. One table contains names of facts on another: 

Fact Table:

Fact_ID   Fact_Name

1            Value

2            Volume

3            Units

The other Table has all the data with the Fact_ID's as column headers:

Customer_ID  Date   1 (Fact_ID)  2(Fact_ID   3(Fact_ID)

123                 01.01.18   253,5      25            36

Is there a way that I can connect the to tables and then rename the columns in the data table to the Fact_Names so that I get:

Customer_ID  Date         Value      Volume    Units

123                 01.01.18   253,5      25            36

Br Kent

[Seward12533 · Accepted solution]

there may be other ways but this works. 

https://1drv.ms/u/s!AuCIkLeqFmlhhJtFY3gZFrFHZDoxlQ

Did this in the query editor

• From Headers Table
  • Add Dummy Columns with values set the names of any leader columns in the source data 
  • Demote Headers
  • Reorder Columns 
  • Keep only 1st  Row
• Append Headers and Fact Tables 
  • Promote 1st Row as headers

Save and Load 

Tip - if you want to not have the orignal Headers and Fact Tables you can set them to not load (right click over query and uncheck Load

[Anonymous]

Wunderfull Seward12533!,

That is good enough for me!

Thanks!