Forum Discussion

sebastianharg's avatar
sebastianharg
Frequent Visitor
5 years ago
Solved

Problem with cumulative column

Hello! I have a problem with this cumulative column, I dont know what im doing wrong, but the cumulative always show the result of  "total dolar" and not the cumulative as I want.   the measure "Lo...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi,  sebastianharg 

    If you are referring to the monthly cumulative calculation, please change your formula as follows:

     

    Cumulative Loan Balance = 
CALCULATE (
    [Loan Balance],
    FILTER (
        ALL ( TANGODB2 ),
        ( TANGODB2[FECHA_EMIS].[Ano] = MAX ( TANGODB2[FECHA_EMIS].[Ano] ) )
            && (
                TANGODB2[FECHA_EMIS].[Mes] = MAX ( TANGODB2[FECHA_EMIS].[Mes] )
                    && ( TANGODB2[FECHA_EMIS] <= MAX ( TANGODB2[FECHA_EMIS] ) )
            )
    )
)

     

     

    Best Regards,
    Community Support Team _ Eason

sebastianharg's avatar
sebastianharg
Frequent Visitor
5 years ago

Any Ideas? thanks!

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi,  sebastianharg 

If you are referring to the monthly cumulative calculation, please change your formula as follows:

 

Cumulative Loan Balance = 
CALCULATE (
    [Loan Balance],
    FILTER (
        ALL ( TANGODB2 ),
        ( TANGODB2[FECHA_EMIS].[Ano] = MAX ( TANGODB2[FECHA_EMIS].[Ano] ) )
            && (
                TANGODB2[FECHA_EMIS].[Mes] = MAX ( TANGODB2[FECHA_EMIS].[Mes] )
                    && ( TANGODB2[FECHA_EMIS] <= MAX ( TANGODB2[FECHA_EMIS] ) )
            )
    )
)

 

 

Best Regards,
Community Support Team _ Eason