Different roles workload calculation

Hey Anonymous ,

my understanding is that the people involved with the project are stored as comma separated list, meaning Project A has 3 people, and Project B has only 1 (James). This is an assumption based on the sample data visualized in the screenshot from your initial post.

I do not fully understand how it is possible to determine the role the person is playing in the project assigning the effort points to the role the person.

Depending on your ideas of the further development changing the structure of your project inventory list or at least deriving a proper data model. This is because multi-valued cells like Project Lead (assumption based on the data visualization in the screenshot) are only a simple "string" in the tabular world.

Consider creating a pbix file that contains sample data but still reflects your data model (tables, relationships, calculated columns, and measures), upload the pbix file to onedrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data (instead of the manual input method) share the Excel file as well.

Next, elaborate on the ideas of how you want to proceed your existing solution.

Regards,
Tom