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 There,
I have a table that I need to transform into a proper table. I'm developing a timesheet table based on MS Forms output. User can input up to 5 projects. Each project is housed in 1 column, the same with the hours columns. So I ended up with 3 Project columns and 3 Hours column
My Final table should only have 1 Column for Project and Hours, each. Illustration below for reference:
Once table is done, it'll be linked to PowerBI report.
Thanks in advance for the help.
Solved! Go to Solution.
It's OK. I manage to solve it, but in a round about way:
1. Merge Column Project & Hour with delimiter, resulting in 3 new columns
2. Unpivot, then you'll only have 1 value of Attribute, which is the Column from #1
3. Split the Value column with delimiter
With this I have the columns that I want. 🙂
yeah, right. Do the project columns have random names or are the always called Project1-5?
It's OK. I manage to solve it, but in a round about way:
1. Merge Column Project & Hour with delimiter, resulting in 3 new columns
2. Unpivot, then you'll only have 1 value of Attribute, which is the Column from #1
3. Split the Value column with delimiter
With this I have the columns that I want. 🙂
perfect, have a nice day!
Hi,
I try to unpivot, but it gaves a half solution. How should I transpose the attribute & value, but only to 2 columns while retaining to the Name & Date column?
User | Count |
---|---|
73 | |
72 | |
39 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
51 | |
43 | |
42 |