Forum Discussion
project hours tracking
Hello, everybody,
Currently I have the following problem in Power Bi. I've been trying to show the following for days:
I would like to have the different hours in a project displayed to me.
The values per week should be displayed and calculated.
The projects start at different times and have different durations.
Each week within each project has a different hourly basis.
And now my question: How do I link the date values "Date per Wx" with "H per Wx" in order to display which hours were incurred at which date?
Enclosed are the Excel spreadsheet (raw data) and an example Power BI. (The screenshot must be read line by line.
Later all values are to be displayed in a line diagram. e.g. On the day "DT per W1" "H per Wx" hours are to be displayed and so on.
Many thanks
Dominic
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
2 Replies
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