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.
Anonymous
Where is the Resource # column? Are you refering to # of FTE or # of Contractor columns?
Do you only have 4 sets of Resource # Name and Resource Hrs/Week columns?