Forum Discussion

marcio_fornari's avatar
marcio_fornari
Icon for Resolver I rankResolver 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's avatar
    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] )
            )
    )
)

     

     


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi marcio_fornari ,

 

We can try to 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[RAZÃO SOCIAL] <= MAX(fDADOS[RAZÃO SOCIAL])
    )
)

 

 

 

If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared？


Best regards,

marcio_fornari's avatar
marcio_fornari
Icon for Resolver I rankResolver I
6 years ago

Hello, v-lid-msft  Thanks for all. It's Almost

 

The Expected Result is:

 

 

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    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] )
            )
    )
)

     

     


    Best regards,