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.
Hi,
I have a table in PowerQuery that is built in a following way:
Name | Primary Cost Center | Secondary Cost Center | Primary FTE | Secondary FTE |
Employee 1 | CC1 | CC2 | 0.5 | 0.5 |
Employee 2 | CC1 | 1 |
I would like to have a query showing data in layout like this:
CC1 | 1.5 |
CC2 | 0.5 |
Do you have any tips how to do it in a smart way? Do I need to transform the table?
Solved! Go to Solution.
@matal4 try the following
1) Duplicate the tables and call it lets say table2
2) rename primary cost center & primary fte cols to cost center and fte in orig table
3) delete secondary cost center & secondary fte cols from orig table
4) group by fte by cost center in orig table
5) rename secondary cost center & secondary fte cols to cost center and fte in table2
6) delete primary cost center & primary fte cols from table2
7) group by fte by cost center in table2
😎 union these tables which have been grouped by cost center
@matal4 try the following
1) Duplicate the tables and call it lets say table2
2) rename primary cost center & primary fte cols to cost center and fte in orig table
3) delete secondary cost center & secondary fte cols from orig table
4) group by fte by cost center in orig table
5) rename secondary cost center & secondary fte cols to cost center and fte in table2
6) delete primary cost center & primary fte cols from table2
7) group by fte by cost center in table2
😎 union these tables which have been grouped by cost center
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |