Forum Discussion
Solved
Composing text with null values replaced by nothing
I'm trying to compose a text (to define the location of a file) that is made of the combination of Drilled down values (concatenated with "&") The problem I face is that there are instances when som...
Text.Combine function can ignore the null value in its first parameter.
Maybe the solution by CNENFRNL is more elegant, easier to use in case you have more columns (like I had)?
Table.AddColumn(#"Replaced Value", "Custom", each ([A]??"") & ([B]??"") & ([C]??""))
Solved: Custom column to combine two Colum returns null if... - Microsoft Fabric Community