Forum Discussion
kgshooter
3 years agoRegular Visitor
Joining/Merging Tables Based on Column Value
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 ...
- 3 years ago
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.
Greg_Deckler
Community Champion
3 years agokgshooter 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.