Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
there may be other ways but this works.
https://1drv.ms/u/s!AuCIkLeqFmlhhJtFY3gZFrFHZDoxlQ
Did this in the query editor
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
there may be other ways but this works.
https://1drv.ms/u/s!AuCIkLeqFmlhhJtFY3gZFrFHZDoxlQ
Did this in the query editor
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
Wunderfull Seward12533!,
That is good enough for me!
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |