Skip to content

Instantly share code, notes, and snippets.

@ninmonkey
Created July 6, 2022 20:52
Show Gist options
  • Save ninmonkey/886125e2b9e4b1cd64b5489ef2b87ac7 to your computer and use it in GitHub Desktop.
Save ninmonkey/886125e2b9e4b1cd64b5489ef2b87ac7 to your computer and use it in GitHub Desktop.
power-query-null-coalesce.pq
let
joinText = (source as list, options as nullable record) as text =>
let
culture = options[Culture]? ?? "en-us",
sep = options[Separator]? ?? ", ",
asText = List.Transform(
source, each Text.From( _, culture ) ),
render = Text.Combine( asText, sep )
in
render
in
joinText
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment