Forum Discussion
Unpivot
Hello all... I would like to have Resource #, Resource Name, and Resource Hrs/Week columns instead of how the data is organized in the first table below. I selected the other columns (Total # of FT...
Anonymous
I am not sure how to create the table for dynamic number of Resource # Name and Hrs/Week columns. Maybe someone out here could help with M query.
If we know the columns are fixed, i could use DAX to create a new table and generate some kind of index as key.
Dax:
Table 2 = UNION(SELECTCOLUMNS('Table (3)',"Resource",'Table (3)'[Resource 1 Name],"Hrs/Week",'Table (3)'[Resource 1 Hrs/Week]),SELECTCOLUMNS('Table (3)',"Resource",'Table (3)'[Resource 2 Name],"Hrs/Week",'Table (3)'[Resource 2 Hrs/Week]),SELECTCOLUMNS('Table (3)',"Resource",'Table (3)'[Resource 3 Name],"Hrs/Week",'Table (3)'[Resource 3 Hrs/Week]),SELECTCOLUMNS('Table (3)',"Resource",'Table (3)'[Resource 4 Name],"Hrs/Week",'Table (3)'[Resource 4 Hrs/Week]))InputOutputIf this helps, mark it as solution.Kudos are good too.
What is the analysis you want to perform will decide the step?
You have to rename the column. And then use it as per need.
Refer
I thought I was clear regarding what I'm trying to accomplish, but to add more context, I'd like to be able to pull a "Resource" field in to a table instead of the "Resource #1, Resource #2, etc. fields.
The link you sent just shows how to perform the steps that I already took.