Multiplication of total values over a matrix table

[Syndicate_Admin]

Hello community!

To put you in context. I am trying to graphically represent the necessary personnel resources depending on the projects we could hire. For this I have the following information:

I have created an array table of %_Distribution_by_Type dimensions where projects are classified by Type (Type_of_Project) and duration (Project_Duration).

In each of the columns (M-1, M-2...) there is a % that represents the percentage of the "Total Hours" that is consumed month by month.

On the other hand I have a table of facts (Projects) with the following information:

What I am trying to achieve is a third table that, depending on theType Of Project and duration, multiplies the column Total_Hours by each of the % that apply to it.

Also, how do I need to make a temporal distribution, so you have to calculate the end date based on the duration of the project End_Date = Start_Date + Duration (Months).

As a final result I seek to represent graphically something like this:

I attach the .pbix file in case you could help me!!! EXAMPLE.pbix

Thanks a lot!!

[v-henryk-mstf]

Hi @Syndicate_Admin ,

The link provided is temporarily inaccessible, can you share this pbix file in another way?

Looking forward to your reply.

Best Regards,
Henry

[MFelix]

Hi @FranRQ ,

The link you have shared is asking for password and we cannot access it.

On the second hand to what I can see you the allocation of your time is based on the number of months so depending on this you can have different results, for this you need to have your months on each projects to be order by the first month , second month and so on for the calculation to be correct. I have done a similar exercise to this with a different setup but for the your needs this can be adjusted.

https://pbiportugal.com/2021/05/26/comparar-n-mes-vendas/

This is in portuguese but google translator works preety well.

If you share your file I can try and get the result that you need.