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'm trying to get the Payroll Subservices field to be on one row for each company. So for each company, instead of having multiple rows I would like to have:
3385 Payroll-Full;Checks-Full;NewHire-Mini
0002 Payroll-Full;Checks-Full
0008 Payroll-Full;NewHire-Full;Checks-Full
etc.
etc.
Solved! Go to Solution.
In Query Editor, do a 'group by' on co, select All Rows.
Add a Custom Column using the syntax = [Combined][Payroll Subservices] where 'Combined' is the new column name from the 'group by' step.
You can then expand the new column (extract values) and you will be offered options to select a delimiter. Choose ';'
In Query Editor, do a 'group by' on co, select All Rows.
Add a Custom Column using the syntax = [Combined][Payroll Subservices] where 'Combined' is the new column name from the 'group by' step.
You can then expand the new column (extract values) and you will be offered options to select a delimiter. Choose ';'
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |