Forum Discussion

arhan1234's avatar
arhan1234
New Member
8 years ago
Solved

Volume €/ month in a graph

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's avatar
    v-jiascu-msft
    8 years ago

    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's avatar
    arhan1234
    8 years ago

    Thanks a lot, it is just I needed! :robotvery-happy:

     

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      arhan1234
      New Member
      8 years ago

      Thanks a lot, it is just I needed! :robotvery-happy: