Forum Discussion
Solved
Concatenate EXCEPT where blank
Hey everyone! I have 2 columns which I'm trying to concatenate with a "/" - However, in some instances, the 'Tr.prt' column is blank. Where this occurs, I don't want the concatenation to happen a...
Good day MeganMarkey,
It may be that the solutions given do not work for as they are DAX solutions and you may be working in Power Query. As you posted in the Power Query forum I'll give you a Power Query solution. Add a custom column using the following code,
= if [Tr.prt] = "" then "" else [CoCd] & "/" & [Tr.prt]
Hope this helps
collinsg
Solution Sage
Solution SageGood day MeganMarkey,
It may be that the solutions given do not work for as they are DAX solutions and you may be working in Power Query. As you posted in the Power Query forum I'll give you a Power Query solution. Add a custom column using the following code,
= if [Tr.prt] = "" then "" else [CoCd] & "/" & [Tr.prt]
Hope this helps