Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am currently working with some data that comes in the format:
Column 1 | Column 2
Title 1 StringValue
Title 2 StringValue
Title 3 Table
Basically column 2 can either contain a string or a table. The table itself is single column and contains multiple values for its title. If a title has more than one value, it is represented by a table in the column cell.
I would like to expand this so that we can have multiple rows per title to represent it's values Such as:
Title 1 StringValue
Title 2 StringValue
Title 3 StringValue(1)
Title 3 StringValue(2)
I'm a little stuck here and sure i'm missing something, any ideas?
Hi kishengandhi,
You can try to pivot the table based on some rows to avoid the duplicate columns. For details about pivot table:
http://radacad.com/pivot-and-unpivot-with-power-bi.
Regards,
Jimmy Tao
Hi, still trying to work this one out. Please see screenshot of data structure. As you can see some cells are text, some are a table that contains a single a column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |