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
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