Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure with non aggregated String

I created a table contain 20  string columns, now I am trying to convert to matrix since I can frezze ID column like Excel. When I put string column in value filed. I have to aggrate the column. It c...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Anonymous ,

     

    As parry2k  said, the prerequisite for the transformation is that there needs to be a column that can be used as a separate identification column, and an index index column can be created in the power query. Then put its field into the column. Refer to the following operation:

    If the problem is still not resolved, please point it out. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Super User
4 years ago

Anonymous If you have same id for all the rows, you cannot do anything, you need to have a unique column on the rows, maybe add a index column in the power query and use that on the rows.

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

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.