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 ...
  • 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:

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft 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: