Forum Discussion

Theycallmesnack's avatar
Theycallmesnack
Frequent Visitor
4 years ago
Solved

Convert three columns with repeating rows into a primary key, field columns, and associated rows?

Hi PowerBI folks,    I'm at the last stretch of a fairly lengthy process where I ingested and parsed a series of XML files into constiuent tables. Each table contains a primary key (survey ID), a f...
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    Pivot the demographic column (demographic values in the Values section) and "Don't aggregate" under Advanced.

    I think that's what your after.

    Let me know.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

Pivot the demographic column (demographic values in the Values section) and "Don't aggregate" under Advanced.

I think that's what your after.

Let me know.