Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I have looked at similiar posts but the solutions presented did not seem to work for me.
I am very new to PowerBI and I have the following sampe data set:
I am trying to achieve the below in a new table:
I need to sum the total for each type by period but then tranpose the periods to rows and have the types as columns.
I have been playing with the summarize function and the closest I have got to is:
Any help much appreciated. Thanks
Solved! Go to Solution.
Hi, @stu_adz
You can try the following methods. Select the first two columns-Unpivot Other columns:
Result:
Using the matrix view:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @stu_adz
You can try the following methods. Select the first two columns-Unpivot Other columns:
Result:
Using the matrix view:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can unpivot this from Power Query.
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Hi, thanks for your reply.
When I apply this to my data, I get an error message that says:
Column 'Period 1 Value' in table '23_24' cannot be found or may not be used in this expression. Column 'Nominal' in Table '23_24' contains a duplicate value '0001-0001' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
This is because I have other table that are linked to the one I am unpivoting. Is there another way around this?
Thanks
User | Count |
---|---|
94 | |
79 | |
75 | |
64 | |
60 |
User | Count |
---|---|
106 | |
98 | |
76 | |
63 | |
61 |