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.
Hello experts, How to get the down table from the above one in the image, please?
Solved! Go to Solution.
Hi.
In Power query select your first column and choose the option Unpivot Other Columns
Best regards.
Hi @koorosh ,
As they said, you could use unpivot in power query; and another method is to create a new table through the following form:
Newtable =
VAR _new1 =
SUMMARIZE ( 'Table', [Company Name], [Service1], "Type", "Service1" )
VAR _new2 =
SUMMARIZE ( 'Table', [Company Name], [Service2], "Type", "Service2" )
VAR _new3 =
SUMMARIZE ( 'Table', [Company Name], [Service3], "Type", "Service3" )
RETURN
UNION ( _new1, _new2, _new3 )
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @koorosh
I tried the following solution.
First, you need to select the columns and then unpivot them(refer to screenshot 1).
Screenshot 1:
Which will give you the following output(refer to screenshot 2):
Screenshot 2:
If you find the solution useful please mark my post as a solution!
In doing so, you are also helping me. Thank you!
Mintu Baruah
Hi.
In Power query select your first column and choose the option Unpivot Other Columns
Best regards.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |