Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Difference per cumulative amount

Hi,    I calculate the difference saldo per month? I only have now the cumulative total saldo per month. This value increases. Thanks, Leon
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    Please check below formula to get last saldo.

    Column =
CALCULATE (
    SUM ( Table1[Saldo] ),
    FILTER (
        Table1,
        Table1[Cat] = EARLIER ( Table1[Cat] )
            && Table1[Index]
                = EARLIER ( Table1[Index] ) - 1
    )
)

    Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks this is a good start however the diff calculation should apply to a specific category condition for which I created a specific index

 

 CAT   Saldo   Index    

CAT A;  50 ;    1

CAT A;  100;   2
CAT A;  200;   3  

CAT B:     25;    1

CAT B:      75;   2

CAT B:    100;   3

 

Thanks!

 

 

 

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

Please check below formula to get last saldo.

Column =
CALCULATE (
    SUM ( Table1[Saldo] ),
    FILTER (
        Table1,
        Table1[Cat] = EARLIER ( Table1[Cat] )
            && Table1[Index]
                = EARLIER ( Table1[Index] ) - 1
    )
)

Regards,