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.
I'm trying to merge data from two tables either into the one of the tables or create a new merged table if I need to. I've looked and looked and don't know how to make this happen. It seems like a relatively easy concept but I'm very new to Power BI. Thanks for any help anyone can provide.
Table: Data | |
Lane | Period |
A | P01 |
A | P01 |
A | P02 |
B | P01 |
B | P02 |
C | P01 |
Table: Baseline | ||
Lane | P01 | P02 |
A | 5 | 7 |
B | 3 | 2 |
C | 1 | 4 |
Desired outcome | ||
Lane | Period | Baseline |
A | P01 | 5 |
A | P01 | 5 |
A | P02 | 7 |
B | P01 | 3 |
B | P02 | 2 |
C | P01 | 1 |
Solved! Go to Solution.
@kgshooter See the attached PBIX file. You unpivot your Baseline P01, P02 columns, rename Attribute column to Period and then you can merge that table into Data using both Lane and Period columns.
@kgshooter See the attached PBIX file. You unpivot your Baseline P01, P02 columns, rename Attribute column to Period and then you can merge that table into Data using both Lane and Period columns.
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 |
---|---|
114 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |