Forum Discussion
Function working with String but not with Column
I got this line Additional_Info = Table.AddColumn(Location_Office, "Additional_Info", each getRemaining("test test", Text.Split(Text.Combine({[Column2], [Column3], [Column4], [Column5]}, "#(lf...
Yes, I see that in the function steps, however, did you test nulls? What value and type is in Column 1? The reason I ask is because when if statements are included in functions and the function is invoked, the behavior is slightly different than it would be if included outside of the function.
It can be null and text. For null I made a special case: Combined = if text <> null then let ... else Combined = null
Yes, I see that in the function steps, however, did you test nulls? What value and type is in Column 1? The reason I ask is because when if statements are included in functions and the function is invoked, the behavior is slightly different than it would be if included outside of the function.