Volume €/ month in a graph

[arhan1234]

Hello all,

I would need some help with a monthly workload forecast table.

Source of the data is an Excel.

My main aim is to see people's workload (Volume €/ month) during the confirmed and active projects, that's between their Start and End dates, and sum them per month.

How could we graph Volume € in a monthly timeline and filter it using "Confirmed" and "Type" variables?

I've tryed my best, but I can only get the amount only in a date, not during the project lifetime.

Thanks a lot,

Regards

[v-jiascu-msft · Accepted solution]

Hi @arhan1234,

Please try out the demo in the attachment. 

1. Create a Date table.

2. Don't establish any relationship.

3. Create a measure. 

Measure =
CALCULATE (
    SUM ( Table137[Volume €/month] ),
    FILTER (
        Table137,
        Table137[Start] <= MIN ( 'Calendar'[Date] )
            && Table137[End] >= MAX ( 'Calendar'[Date] )
    )
)

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @arhan1234,

Please try out the demo in the attachment. 

1. Create a Date table.

2. Don't establish any relationship.

3. Create a measure. 

Measure =
CALCULATE (
    SUM ( Table137[Volume €/month] ),
    FILTER (
        Table137,
        Table137[Start] <= MIN ( 'Calendar'[Date] )
            && Table137[End] >= MAX ( 'Calendar'[Date] )
    )
)

Best Regards,

Dale

[arhan1234 · Accepted solution]

Thanks a lot, it is just I needed!