Cumulative Total without date

Question

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(&nbsp;&nbsp;&nbsp;&nbsp;[IMPORTE],&nbsp;&nbsp;&nbsp;&nbsp;FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALLSELECTED('Dim Calendar'[date]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ISONORAFTER('Dim Calendar'[date], MIN('Dim Calendar'[date]), ASC)&nbsp;&nbsp;&nbsp;&nbsp;))But was wrong. i need it for General Ledger.Can someone help me? I will appreciated all your help.&nbsp;&nbsp;

fowmy · Accepted Answer

JoanElGran1899&nbsp;Not quite understood the model but can you try the following measure to get the accumulation based on the account number&nbsp; 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] &lt;= __acc
    )
)

Forum Discussion

Cumulative Total without date

2 Replies

Related content

Cumulative Total

Cumulative Total

SumX? - cumulative running total

Cumulative Total

Cumulative total