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.

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
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.