Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all
I have a list like
List |
8 |
abc |
2021.01.01 13:45:00 |
011010 |
How can I convert this list to a table? Is there a function or do I need to do it manually?
Should look something like
Value | text | time | bit |
8 | abc | 2021.01.01 13:45:00 | 011010 |
Since the source is a list, transforming options like pivot, unpivot are not available.
Trying to convert the list in a table "to table" results in errors, since each row is another type.
best
aleks
Solved! Go to Solution.
Fount the solution
When converting "to table" you have to choose as a delimiter "none".
After that it is possible to transpose the table.
Fount the solution
When converting "to table" you have to choose as a delimiter "none".
After that it is possible to transpose the table.
@Anonymous ,
Try unpivoting using power query.
https://www.myexcelonline.com/blog/unpivot-data-using-excel-power-query/
Regards,
Manikumar
Proud to be a Super User!
Since this is a list, options like unpivot are not available. I think I have to use dax.
@Anonymous , with the first table it seems like a case for transpose table or unpivot
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
The problem is, it is not a table, therfore transpose or unpivot are not available. it's a list.
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |