Obtain the totals per month in a Gantt chart (that is, between 2 dates - start and end - of each act

[Anonymous]

Hi everyone, I have a problem that I can't solve and I need some help please.

I have a series of activities with their start and end dates (taking into account only working days, not weekends, the durations are already calculated like this). Some are distributed over several months. I would like to be able to obtain a total of money for each month of the activities (marked in red in the lower part of the image). I understand that this cannot come out of the different Gantt charts but in a table, that is not a problem.

Thank you very much for your help and for your time.

[Icey]

Hi @Anonymous ,

How about grouping two visuals together to get what you want?

For example, use a Table visual to show total values and place it in the lower part of the gantt chart?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @Anonymous ,

You need to make the count of the number of days per month and the multiply that by the total per day.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.