Forum Discussion

kfloyd3000's avatar
kfloyd3000
Regular Visitor
3 years ago
Solved

Split rows according to values

Hi all!   I am new to Power BI and need some help to split into 2+ rows the registries that contain an A in the column2 field. I have searched accross the web and tutorials but havent find an answe...
Need Help
Tips and Tricks
  • Jakinta's avatar
    Jakinta
    3 years ago

    Paste this code in new blank query and use/adjust steps to your query.

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjExN1KK1QEzLKAMC0NHIAEVNrMwgDIszWEMS0cTc0MTpdhYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column2 = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each let a=Number.FromText ( Text.BeforeDelimiter([Column2],"A") ), b= Number.FromText ( Text.AfterDelimiter([Column2],"A") ) in if Text.Contains([Column2],"A") then {a..b} else {[Column2]}),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom")
in
    #"Expanded Custom"