Forum Discussion

JQuon's avatar
JQuon
Icon for Helper I rankHelper I
8 years ago
Solved

Combine multiple columns (exclude blanks) into two columns with a new category column

I'm able to achieve the following in SQL with a union all and where clause, but would like to be able to do this in PowerBI  
Need Help
JQuon's avatar
JQuon
Icon for Helper I rankHelper I
8 years ago

After hours of trial and error with union and selectcolumns function, I was able to find a solution using your suggestion.  Thanks for putting me on the right track.