Forum Discussion

Resolver I

6 years ago

Solved

Cumulative Sum with Duplicate Date

Hello, I have a problem to sum a Cumulative Measure. Maybe this is happening because there duplicate Dates? If don't have duplicate dates: It's OK But, if have a "RAZAO SOCIAL" value in...

Need Help

v-lid-msft

6 years ago

Hi marcio_fornari ,

Sorry for our mistake in the formula, we can use the following measure to meet your requirement:

Acumulado Saldo =
CALCULATE (
    [Saldo do Dia];
    FILTER (
        ALL ( fDADOS );
        fDADOS[DATA VENCIMENTO] < MAX ( fDADOS[DATA VENCIMENTO] )
            || (
                fDADOS[DATA VENCIMENTO] = MAX ( fDADOS[DATA VENCIMENTO] )
                    && fDADOS[RAZÃO SOCIAL] <= MAX ( fDADOS[RAZÃO SOCIAL] )
            )
    )
)