Calculate time model of items

[Anonymous]

Hello everyone,

I am still new to PBI..

I have a number of items that can take either 120, 140 or 160 days to complete.

ITEM                   Duration (in days)

Item 1	120
Item 2	140
Item 3	120
Item 4	140
Item 5	160
Item 6	160

With 228 items, and a start date of 01/01/2022 up to perhaps 31/12/2034, I wish to vizualise how long it would take me to complete all tasks.

I see it with a slider I can use to indicate that I want to do 30 items per year, or 10 iteams per year or 3 items per year.

Of course, if I have 30 items per year, that would mean that I need to have probably 15 teams working on those items to have them completed in time.

I can't quite grasp how I should get that calculation of items per year, that would afterwords influence all the rest of my data..

Do you have any recommandations?

With all my thanks,
Marc

[lbendlin]

" I want to do 30 items per year, or 10 iteams per year or 3 items per year"

Which items are you selecting?  from the list tops down, or from a slicer?

Please provide sample data that matches your problem description.

[Anonymous]

Thank you for you response.

Well, here is the link to download my PBI and the Excel sheet used.

The Excel sheet used has the nominated items, ID's associated, number of days to accomplish each items (round up is 140 days).

I have a number items (228), and a parameter of 30 per year of these items doable. I want to modelize how long it would take to do those 228 items if I do 30 per year, or 29, or 28.

I added another parameter to include the teams. If I have one team, it would be 30 per year. If I have 2 teams, it would be 60 per year.

So I do have my visual indicating that for 228 items, 1 team and 30 per year, it would take me 7,6 year until completion. 

But I can't get to have a graphic showing the years 2022 to lets say 2034 and how many items are completed each year, until the last year where I won't obviously have 30 items.

I have created a calendar in my PowerBI. But it has no active relation with my main source of data.

Thank you for you reply in order to create this visual date/accomplishments of tasks.
Best regards,
Lotam

[v-jingzhang]

Hi @Anonymous 

Sorry I don't quite understand your expected result. If you have a parameter to decide e.g. 30 items per team per year and another parameter to decide the number of teams you have, then for each year, the number of completed items ought to be parameter1 * parameter2, right? If so, it is

Completed Items = [Valeur Nombre de Stations par an]*[Valeur Nombre d'équipe SSI]

According to this logic, I don't see how Duration days influence the result? Do you need to consider Duration days of each item? And do you need to consider the precedence of items to be accomplished? If those should be taken into account, what is the logic to achieve the result?

Best Regards,
Community Support Team _ Jing