Forum Discussion
Concatenate isNOTblank Query
Is there a way I can combine / concatenate multiple columns when some of them contain blanks? Here is a few I need together [Deviation Category] and [Deviation Category_1]
5 Replies
Do you have to do it in Power Query? I don't see an issue with DAX doing that. [Column 1] & [Column 2] & [Column 3]
- Hi Anonymous
On the query editor you should use something like
If columnq = null then "" else column 1 & If column2 = null then "" else column2
Should do the trick.
Do this Hi Anonymous
Based on my understanding, the columns you want to concatenate are which columns' headers has similar text like [Deviation Category] and [Deviation Category_1],
Finally result should be like:
Deviation Category TB# Late Pickup Communication 1.23 Is my understanding correct?
Best Regards
Maggie
