Forum Discussion

paolomint's avatar
paolomint
Icon for Helper III rankHelper III
5 years ago
Solved

variation on rolling sum

Hi every one, I have the following table:   Due date Costumer credit limit debit 01.06.2021 SRD inc 10.000 3000 13.06.2021 SRD inc 10.000 2000 20.06.2021 SRD inc 10.000 100...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, paolomint 

     

    You can try like this:

    Column =
'Table'[credit limit]
    - SUMX (
        FILTER (
            'Table',
            [Due date] > EARLIER ( 'Table'[Due date] )
                && [Costumer] = EARLIER ( 'Table'[Costumer] )
        ),
        [debit]
    )

    Best Regards

    Janey Guo

     

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

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, paolomint 

 

You can try like this:

Column =
'Table'[credit limit]
    - SUMX (
        FILTER (
            'Table',
            [Due date] > EARLIER ( 'Table'[Due date] )
                && [Costumer] = EARLIER ( 'Table'[Costumer] )
        ),
        [debit]
    )

Best Regards

Janey Guo

 

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