Forum Discussion
New2PowerBI
9 years agoHelper III
How to Join Two Columns Into One Based on Data Values
I have a dilemma in my Tables and Columns. We manage preventative work in an application and I'm working with that data. I notice that when the preventative work is tied to an "Asset", the "Location"...
- 9 years ago
New2PowerBI
9 years agoHelper III
Thanks; saw the video but cannot select both columns, they are in different tables and when I try and use Shift and/or Control with a Click Select, one of the selections defaults to the first column of the last table, so it merges a different column and not the one I want. Is there another way to select them?
New2PowerBI
9 years agoHelper III
I also went to each table and moved the column of Location to the beginning to see if that would make the selection easier but it didn't.