Forum Discussion
Sansudhi8
Helper III
Helper IIIRemove space between first name and last name
Dear All, Kindly look into the attached PBI . It contains charge for provider by unique ID. I want to create a sclicer for provider. There are some items which have space between first name and last...
Hi Sansudhi8
This the result you need?
try this in m query:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jdNNCsJADAXgq8jgskj+ZvKyVOiiWFyou9L7X8P2Aibb8tE8kjfb1oSsh482te97eT3Xebosn/tjXo8vV7Zxa/t0qmFmkqugyr+COxeUiabKiSif6MRuBaUauVL2gjJQvq9T9Vx1Gvm+fEjhQn4sH7lyNa+oUZgI1UL6EKGCUq0oaJ4ex73zTYAi8vRg5sJEVuTXBgN5v8Chee8hgrz3pyqklx75e4SMQicgLn/T7z8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Uniq ID" = _t, Provider = _t, TotalCharge = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Uniq ID", Int64.Type}, {"Provider", type text}, {"TotalCharge", Currency.Type}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.BeforeDelimiter([Provider], " ") & Text.AfterDelimiter([Provider], " ")) in #"Added Custom"
mussaenda
Community Champion
Community ChampionHi Sansudhi8
This the result you need?
try this in m query:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jdNNCsJADAXgq8jgskj+ZvKyVOiiWFyou9L7X8P2Aibb8tE8kjfb1oSsh482te97eT3Xebosn/tjXo8vV7Zxa/t0qmFmkqugyr+COxeUiabKiSif6MRuBaUauVL2gjJQvq9T9Vx1Gvm+fEjhQn4sH7lyNa+oUZgI1UL6EKGCUq0oaJ4ex73zTYAi8vRg5sJEVuTXBgN5v8Chee8hgrz3pyqklx75e4SMQicgLn/T7z8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Uniq ID" = _t, Provider = _t, TotalCharge = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Uniq ID", Int64.Type}, {"Provider", type text}, {"TotalCharge", Currency.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.BeforeDelimiter([Provider], " ") &
Text.AfterDelimiter([Provider], " "))
in
#"Added Custom"
