cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

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

1 ACCEPTED SOLUTION
Super User

@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
)
)``````

Did I answer your question? Mark my post as a solution! and hit thumbs up
2 REPLIES 2
Super User

@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
)
)``````

Did I answer your question? Mark my post as a solution! and hit thumbs up
Frequent Visitor

It was exactly what i was looking for! 😉

Thank you so much.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors