Forum Discussion

Icon for Helper I rank

Helper 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

v-chuncz-msft
8 years ago
JQuon,

You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.

3 Replies

v-chuncz-msft
Community Support
8 years ago
JQuon,

You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.
- JQuon
  Helper I
  8 years ago
  v-chuncz-msft wrote:
  JQuon,
  
  You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.
  
  Hi Sam,
  
  This puts me in the right direction, but after spending some time googling, I'm stilll having trouble getting the desired results. Could you elaborate a little more? Any help is greatly appreciated. Thanks
- JQuon
  Helper 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.