CONCATENATE INFO FROM COLUMNS INTO ONE

[pezakas]

Hello community,

Here is the following scenario:

I have the data in the following table from columns A-F and i want to create the calculated column G.

Is there any faster and more efficient way do this other than multiple nested IF statements?

Thank you in advance!

[v-jayw-msft · Accepted solution]

Hi @pezakas ,

You still need multiple IF statements.

Please refer this formula:

Column = 
var b1 = IF('Table'[Document B1]="Missing","B1,")
var c1 = IF('Table'[Document C1]="Missing","C1,")
var d1 = IF('Table'[Document D1]="Missing","D1,")
var e1 = IF('Table'[Document E1]="Missing","E1,")
var f1 = IF('Table'[Document F1]="Missing","F1,")
VAR g = b1&c1&d1&e1&f1
return
LEFT(g,LEN(g)-1)

Best Regards,

Jay

[amitchandak]

@pezakas , You need to create a column like 

if([B] = "Missing" , [B], blank() )  & ", " & if([B] = "Missing" , [C], blank() ) & ", " & if([D] = "Missing" , [D], blank() ) & ", " & if([E] = "Missing" , [E], blank() )