Creating a column using 3 other columns

Question

Hello, hope everyone is keeping safe and well.I have 3 columns, only one of which is populated when a transaction takes place. I am trying to create a column (not in Power Query) that combines those results. So for example,TRANS1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRANS2&nbsp; &nbsp; &nbsp; &nbsp; TRANS3&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;My desired columnBanana&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Banana&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Grape&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Grape&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pineapple&nbsp; &nbsp; PineappleKiwi&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KiwiI hope that makes sense, I'm certain I'm missing a very obvious function but I can't see the wood for the trees on this one.I hope someone can help me create my desired column!&nbsp;Thank you in advance 🙂&nbsp;

greg_deckler · Answer

A DAX way of doing it:
&nbsp;
&nbsp;
Column =
  SWITCH(TRUE(),
    NOT(ISBLANK([TRANS1])),[TRANS1],
    NOT(ISBLANK([TRANS2])),[TRANS2],
    NOT(ISBLANK([TRANS3])),[TRANS3]
  )
&nbsp;

greg_deckler · Answer

Seems like you should unpivot those columns in Power Query.

amitchandak · Answer

Anonymous , Try a new column like 
coalesce([TRANS1],[TRANS2],[TRANS3])

anonymous · Answer

This is an excellent solution!Thank you so much 🙂&nbsp;

Forum Discussion

Creating a column using 3 other columns

4 Replies

Related content

Create columns group

New Column

Appending columns and creating new column of old column headers

unpivoting columns and creating datetime column

Creating a date column