Forum Discussion
Helper IIHow to remove blank fields from concatenated column - DAX
Hi Powre BI community,
I need your help for a DAX question : I’m trying to concatenate multiple columns containing text and I want to ignore if the field is empty in one of the columns to be concatenated.
For that I use the following query :
Concatenated col = IF(ISBLANK ('TABLE'[Col1]),BLANK(),'TABLE'[Col1]) & UNICHAR(10) & IF(ISBLANK ('TABLE'[Col2]),BLANK(),'TABLE'[Col2]) & UNICHAR(10) & IF(ISBLANK ('TABLE'[Col3]),BLANK(),'TABLE'[Col3]) & UNICHAR(10) & IF(ISBLANK ('TABLE'[Col4]),BLANK(),'TABLE'[Col4]) & UNICHAR(10) & IF(ISBLANK ('TABLE'[Col5]),BLANK(),'TABLE’[Col5])
The issue is that this gives the following view :
And my objective is removing the empty fields.
Can anyone help me to achieve that please 🙏
Move the UNICHAR(10) inside the IF statements so you will only get a new line if there's a new line that isn't blank
3 Replies
vicky_Super User
Move the UNICHAR(10) inside the IF statements so you will only get a new line if there's a new line that isn't blank
Betty888Very many thanks for your help !
I included the separator in the IF statement, but something strange happened : it works for the firts 6 columns, for all the rest it didn't work even that I'm using the same statement, I'm just changing the column names!!!! In my concatenated column, I'm combining 12 columns in total