project hours tracking

hi Anonymous 

For your case, you need to adjust your data structure for the data table.

You could try this way as below:

Step1:

Duplicate the basic data table.

Step2:

For the basic table, remove H per Wx columns, then selected all H per Wx columns, Unpivot the columns

And Extracted Last two Characters for Attribute column

Step3:

Use the same logic for duplicate table in H per Wx columns

Step4:

Merge basic table and duplicate table as  below:

Step5:

Expand the table

Result:

Here is sample pbix file, please try it.

Regards,

Lin