Forum Discussion

JoanElGran1899's avatar
JoanElGran1899
Frequent Visitor
5 years ago
Solved

Cumulative Total without date

Hi Everyone, I'm at an absolute loss as to how to calculate a cumulative total without data. I tried something like this: Total acumulado de IMPORTE en date = CALCULATE(     [IMPORTE],     FI...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    JoanElGran1899 

    Not quite understood the model but can you try the following measure to get the accumulation based on the account number  which I think is 'Cuenta Contable'

    Total acumulado GL =
var __acc = MAX(Table1[Cuenta Contable]) return

CALCULATE(
    [IMPORTE],
    FILTER(
        ALLSELECTED(Table1[Cuenta Contable]),
        Table1[Cuenta Contable] <= __acc
    )
)




Fowmy's avatar
Fowmy
Super User
5 years ago

JoanElGran1899 

Not quite understood the model but can you try the following measure to get the accumulation based on the account number  which I think is 'Cuenta Contable'

Total acumulado GL =
var __acc = MAX(Table1[Cuenta Contable]) return

CALCULATE(
    [IMPORTE],
    FILTER(
        ALLSELECTED(Table1[Cuenta Contable]),
        Table1[Cuenta Contable] <= __acc
    )
)




  • JoanElGran1899's avatar
    JoanElGran1899
    Frequent Visitor
    5 years ago

    It was exactly what i was looking for! ğŸ˜‰

    Thank you so much.