Cumulative Sum less then Current Date

Hi All,

I need the Cumulative Sum measure for the column based on the less then Current Date which means I want to add the colum "ST_Day_Duration" provided the Contract End Date is less then Today() as seen in the foolowing screen print. I want to Sum the ST_Day_Duration column for India except the contract Date less then today.

Similarly I want to sum the USA except the contract Date less then today.

Please assist with the Mesure or column.

Thanks

Suhel

Create a measure:

Measure = 
IF (
    MAX('Table'[Contract end date]) <= TODAY (),
    CALCULATE (
        SUM ( 'Table'[ST_Day_Duration] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Contract end date] <= TODAY ()
                && 'Table'[Country] = SELECTEDVALUE( 'Table'[Country] )
        )
    )
)

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Cumulative Sum less then Current Date.pbix20 KB

Forum Discussion

Cumulative Sum less then Current Date