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,

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, I am facing a similar issue and the above solution has not worked for me. 
I have data on sales of around 1600 restaurants for the months January-May 2022. Whatever I have tried it just duplicates the selected months' value. I want to make a card that shows Year to date value so e.g if I select April from the slicer so I want the card to show the sum of sales values of that particular restaurant from January-April while excluding months after April.