Forum Discussion

AJPF's avatar
AJPF
Helper I
4 years ago
Solved

pivoting columns

Hello all,    I have some data (only 2 columns) which looks this:    ID Note 100 This 100 is 100 an 200 example 200 of 200 what 300 I  300 need  300 to 300 see   What I want is this: ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    AJPF 

    you can try this

    1. group by

    = Table.Group(#"Changed Type", {"id"}, {{"Count", each Text.Combine([NOTE]," "), type nullable text}})

    2. split the new column by space

    3. change the column name

    pls see the attachment below

     

parry2k's avatar
parry2k
Super User
4 years ago

AJPF pivoting is not a good idea, usually, you want unpivoted data. in this case, you can add an index column grouped by each ID, and then in matrix visual, you can have ID on the rows, INdex on columns, and Note on the values and that will do it. This post will help to add an index.

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡