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 guys,
This is my 1st post on here so hopefully the 1st of many 😀
I've been trying without success to shape the table data below in to something workable.
Each column after the 1st 3 has a monthly value, however contained within each month is a category of "Blended", "Fixed Cost", "Internal" and "T&M". I need to unpivot the all columns to the right of Column 1, 2 and 3, but include these additional categories by month.
For example there should be an additional column with the 4 variable fields above and should look something like this when unpivotted (the category column below is the new column).
The picture below shows the current shape of the data, any assistance you could offer would be hugely appreciated.
Thanks in advance for your support.
Derivco | Column1 | Role | Month | Category | Feb-21 |
Derivco | Confirmed | Dev | Feb-21 | Fixed Cost | 10000 |
Derivco | Confirmed | Auto | Feb-21 | Fixed Cost | 10000 |
Derivco | Confirmed | Arch | Feb-21 | Fixed Cost | 10000 |
Derivco | Confirmed | Prod | Feb-21 | Fixed Cost | |
Derivco | Confirmed | Scrum | Feb-21 | Fixed Cost | 10000 |
Derivco | Confirmed | BA | Feb-21 | Fixed Cost | 10000 |
Derivco | Confirmed | QASME | Feb-21 | Fixed Cost | |
Derivco | Confirmed | Sec | Feb-21 | Fixed Cost | 10000 |
Derivco | Confirmed | MC | Feb-21 | Fixed Cost | 10000 |
Derivco | Confirmed | Dev | Mar-21 | T&M | 44000 |
Derivco | Confirmed | Auto | Mar-21 | T&M | 50000 |
Derivco | Confirmed | Arch | Mar-21 | T&M | 0 |
Derivco | Confirmed | Prod | Mar-21 | T&M | 0 |
Derivco | Confirmed | Scrum | Mar-21 | T&M | 19500 |
Derivco | Confirmed | BA | Mar-21 | T&M | 0 |
Derivco | Confirmed | QASME | Mar-21 | T&M | 0 |
Derivco | Confirmed | Sec | Mar-21 | T&M | 0 |
Derivco | Confirmed | MC | Mar-21 | T&M | 0 |
Hi@patem2,
I'm afraid I didn't understand your needs accurately.
A more detailed sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
How-to-Get-Your-Question-Answered-Quickly
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |