Creating a report based on contingent value

[PowerNewbieT]

Hi folks, I was wondering if you would be so kind to help me with a tricky report. 

Based on the expected date of resource engagement and expected resource use per month, I need to create a view showing how many projected resources would be engaged per project over time. 

I've gotten to the view below, but I can't figure out how to show the value correctly.

For example, 0.40 (40%) of a resource would be needed starting on 5/1/19 for a period of 3 months. This means I need to show 0.40 for three months following the start date of 5/1/19. Another resource is needed to start on 4/30/19 in the amount of 0.25 (25%) for 5 months, which means that in the first three months resource need would be totaled at 0.4+0.25=0.65 (65%).

This was way easier in Excel, when you can create a table with monthly dates across the top and formulas in values showing data bar: "For as long as the 'current date' is less than 'expected engagent date+duration of engagement' and more or equal 'expected engagement date', then resource allocation is at a constant given value "

Any ideas would be greatly appreciated!

Thank you,

T

[v-shex-msft · Accepted solution]

HI @PowerNewbieT ,

Maybe you can try to use gantt chart or timeline charts, they can analysis date duration based on two date fields. (you can find them in marketplace of power bi visuals)

Visual Awesomeness Unlocked – Gantt chart

as Timeline

Regards,

Xiaoxin Sheng