Forum Discussion

Mahamood0218's avatar
Mahamood0218
Icon for Helper II rankHelper II
4 years ago

Spilt the Columns in Power bi Table

Hi Experts,   I have a PBI Table  Active Table with two coulmns(Action_ID and Action_Reactive ) my requirement is by using "Active Table" i want to create Dimension table along with New Column as T...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago
    Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("RchLCoAgEADQu8zaoH/dRVwMIjFgGjoF3T5mIlq+Zy10LRjYkUMhjOCMhV7myJH8rR7EIXF5OQqvHJuUmXzQm76rjHxWvfk73NSLmJKMz8h663+U6gnOPQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [action_id = _t, action_reactive = _t]),
    #"Modificato tipo" = Table.TransformColumnTypes(Origine,{{"action_id", Int64.Type}, {"action_reactive", type text}}),
    #"Aggiunta colonna personalizzata" = Table.AddColumn(#"Modificato tipo", "result", each Text.Reverse(Text.AfterDelimiter(Text.Reverse([action_reactive]),"-")))
in
    #"Aggiunta colonna personalizzata"
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
    let
    Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("RchLCoAgEADQu8zaoH/dRVwMIjFgGjoF3T5mIlq+Zy10LRjYkUMhjOCMhV7myJH8rR7EIXF5OQqvHJuUmXzQm76rjHxWvfk73NSLmJKMz8h663+U6gnOPQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [action_id = _t, action_reactive = _t]),
    #"Modificato tipo" = Table.TransformColumnTypes(Origine,{{"action_id", Int64.Type}, {"action_reactive", type text}}),
    #"Aggiunta colonna personalizzata" = Table.AddColumn(#"Modificato tipo", "result", each if not Text.Contains([action_reactive],"-") then " " else Text.BeforeDelimiter([action_reactive],"-"))
in
    #"Aggiunta colonna personalizzata"