Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Column merge Help !!!!

Good morning all !   I would like your help on a problem that I have been encountering for weeks! I will explain my situation to you very quickly:   In my Power Bi report, I have two tables:   ...
Tips and Tricks
  • Jimmy801's avatar
    Jimmy801
    5 years ago

    Hello Anonymous 

     

    then I would appreciate if you could mark my post as solution. 

    About your other question... what you mean duplicates... you a line with date, material and ADI where in the ADI-column you have two time a ADI-number? Then use this code (not tested)

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bc1LCsAgDIThu2QtJJkkVs8i3v8aPgqWlsIsZvHB3xqJ8hwEQoksKzJE59VgBSOopxvhjRAWi+lm12H2YeZh7kv6lvXI32pZqOSD/EHYvcomHBP0AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Extraction date" = _t, #"Material Code" = _t, #"ADI number" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Extraction date", type date, "en-US"}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Extraction date", "Material Code"}, {{"AllADI", each Text.Combine(List.Distinct(_[ADI number]), ", "), type text}})
in
    #"Grouped Rows"

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Jimmy801 

 

you are a monster, you are too strong your solution works !! ðŸ¤—

I just have a quick question, do you know a way to remove duplicates that may appear in the "ALLADI" column

 

thank you for your help !

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    5 years ago

    Hello Anonymous 

     

    then I would appreciate if you could mark my post as solution. 

    About your other question... what you mean duplicates... you a line with date, material and ADI where in the ADI-column you have two time a ADI-number? Then use this code (not tested)

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bc1LCsAgDIThu2QtJJkkVs8i3v8aPgqWlsIsZvHB3xqJ8hwEQoksKzJE59VgBSOopxvhjRAWi+lm12H2YeZh7kv6lvXI32pZqOSD/EHYvcomHBP0AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Extraction date" = _t, #"Material Code" = _t, #"ADI number" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Extraction date", type date, "en-US"}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Extraction date", "Material Code"}, {{"AllADI", each Text.Combine(List.Distinct(_[ADI number]), ", "), type text}})
in
    #"Grouped Rows"

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy