cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

how create a table to spread the resource allocation

Hello everyone!

 

I have a table like this (from our project management system):

 

Project | Resource | Task | Expected start | Expected end | Expected effort | Actual Jan | Actual Feb | ........ | Actual Dec

 

From this table I would like to get a table like this:

 

Project | Resource | Task | Exp Jan | Exp Feb | ........ | Exp Dec

 

Where Exp Jan is the part of the effort expected for the month of January obtained by dividing Expected effort for the number of months between the Expected start and Expected end.

 

How could I get this?

Thanks for your collaboration!

2 REPLIES 2
ChandeepChhabra
Solution Specialist
Solution Specialist

@Anonymous Looks doable. Can you share some sample data, clearly showing the expected output

Thanks

Anonymous
Not applicable

@ChandeepChhabra , you are right.
Providing sample data my problem is more understandable.

My start table is like this:

Project

Resource

Task

Expected start

Expected end

Expected effort

1

2

3

4

5

6

7

8

9

10

11

12

Project1

Mike

Task1.1

01/04/2019

31/10/2019

100

 

 

 

10

5

 

 

 

 

 

 

 

Project1

Tony

Task1.1

01/04/2019

31/08/2019

80

 

 

 

20

10

 

 

 

 

 

 

 

Project2

Mike

Task2.1

01/01/2019

31/03/2020

400

10

20

15

25

20

 

 

 

 

 

 

 

 

Where the value in column 1, 2, 3.......is the actual effort in month 1, 2, 3.... of the current year.

 

I would like to get a table like this:

Project

Resource

Task

Month

Expected

Actual

Project1

Mike

Task1.1

4

14,3

10

Project1

Mike

Task1.1

5

14,3

5

Project1

Mike

Task1.1

6

14,3

 

Project1

Mike

Task1.1

7

14,3

 

Project1

Mike

Task1.1

8

14,3

 

Project1

Mike

Task1.1

9

14,3

 

Project1

Mike

Task1.1

10

14,3

 

Project1

Tony

Task1.1

4

16

20

Project1

Tony

Task1.1

5

16

10

Project1

Tony

Task1.1

6

16

 

Project1

Tony

Task1.1

7

16

 

Project1

Tony

Task1.1

8

16

 

Project2

Mike

Task2.1

1

26,7

10

Project2

Mike

Task2.1

2

26,7

20

Project2

Mike

Task2.1

3

26,7

15

Project2

Mike

Task2.1

4

26,7

25

Project2

Mike

Task2.1

5

26,7

20

Project2

Mike

Task2.1

6

26,7

 

Project2

Mike

Task2.1

7

26,7

 

Project2

Mike

Task2.1

8

26,7

 

Project2

Mike

Task2.1

9

26,7

 

Project2

Mike

Task2.1

10

26,7

 

Project2

Mike

Task2.1

11

26,7

 

Project2

Mike

Task2.1

12

26,7

 

 

where Expected is the part of the effort expected for the month, obtained by dividing Expected effort for the number of months between the Expected start and Expected end.

In this way I could get a graph like this:2019-05-29_10h10_53.png

How can I get the table I want?

Thank you for your cooperation

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors