Forum Discussion

rviswa's avatar
rviswa
Regular Visitor
6 years ago
Solved

Power BI Mquery

Hi

 

I have a input table with values as below:-

 

Form No  Value

A              M01

A              M02

B              M03

C             M02

C             M01

 

I need the output as below:-

Form No    Value

A                M01,M02

B                M03

C                M02,M01

 

How to do this in Power BI M query?

 

Thanks

Rviswa

Need Help

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    6 years ago

    rviswa 

    In Power Query, insert a Blank Query, goto Advanced editor clear everything and paste below code,

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcssvylXwyz+0QElHKSwxpzRVKVYnWsnx0AIFGAJK+BoYYhc2Ags7oQsbg4WdsavGEAaaHQsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Grouped Rows" = Table.Group(#"Promoted Headers", {"Form No "}, {{"NEW COLUMN", each Text.Combine([Value],", "), type nullable text}})
in
    #"Grouped Rows"



    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

    • rviswa's avatar
      rviswa
      Regular Visitor
      6 years ago

      Thank you. It works.