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

[JQuon]

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 · Accepted solution]

@JQuon,

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

[JQuon]

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.

[JQuon]

---

@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