Skip to content

Instantly share code, notes, and snippets.

@ndthanh
Created August 19, 2020 16:38
Show Gist options
  • Save ndthanh/5fa0f97da7761da718a467f8d188defe to your computer and use it in GitHub Desktop.
Save ndthanh/5fa0f97da7761da718a467f8d188defe to your computer and use it in GitHub Desktop.
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Mix", type text}}),
#"Added Custom" = Table.AddColumn(
#"Changed Type",
"Custom",
each Text.Combine(List.RemoveNulls(List.Transform(Text.ToList([Name]),
each if Value.Is(Value.FromText(_), type number) then _ else null))))
in
#"Added Custom"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment