Forum Discussion
Solved
Combining Columns
Hi everyone! I'd like to combine three columns together. When 'Park Name' is blank, I want it to add data from either community center & pool or community garden. When Park Name is blank then u...
Hey,
In your code you have [Park Name] = """""" for a value, so it looks for """" in the string.
Try:
= Table.AddColumn(#"Renamed Columns", "Combined Locations", each if [Park Name] = "" then [#"Community Center & Pool"] else [Park Name])
olliehernandez Try using null instead of ""