Skip to content

Instantly share code, notes, and snippets.

@ndthanh
Created August 19, 2020 16:38
Embed
What would you like to do?
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