Forum Discussion
Helper IVDAX for Remaining Percent Left and Reflect in Bar Graph
Community SupportHi， third_hicana
I cannot fully correlate your bar chart with the table data provided.
Could you be more specific about your expected results?
Best Regards,
Community Support Team _ Eason
Helper IVHi v-easonf-msft I want to see the remaining percent per month.
The scenario is there is an employee who has a project or multiple projects that has a timeline (i.e the breakdown per month)
For example: I have a project (Project A) that will run from Jan 01, 2022 up to June 30, 2022 and another project (Project B) that will run from Feb 01, 2022 until May 15, 2022. The assigned percent for the project A is 50% and for Project B is 30%. My maximum percent is 100. If I will breakdown those two projects per month, this should be the result
Jan 2022: 100% - 50% = 50%
Feb 2022- 100% -50%- 30% = 20%
March 2022: 100% -50%- 30% = 20%
April 2022:100% -50%- 30% = 20%
May 2022: 100% -50%- 30% = 20%
June 2022 : 100% - 50% = 50%
As you can see it adds and subtracts everytime there is a project starts and ends. So it checks and balance every month how many percent left. The bars in months are calendar month and not the months in the assignment table.
I hope this helps. 🙂