topic Re: cumulative calculation DAX in DAX Commands and Tips

cumulative calculation DAX

Anonymous — Thu, 08 Jun 2023 12:47:57 GMT

I made a DAX formula for camulative calculations.

See dax formula

Cumulatieve Berekening =

CALCULATE(

SUM('Grootboekmutaties huidig jaar'[Saldo]),

FILTER(

ALLSELECTED('Grootboekmutaties huidig jaar'[Omschrijving]),

'Grootboekmutaties huidig jaar'[Omschrijving] <= MAX('Grootboekmutaties huidig jaar'[Omschrijving])

)

It shows all incoming and outgoing transactions. In the other column the transactions calculates calmulatively due to the DAX formula I made. I made a table with date, incoming and outgoing transactions, transaction_ID and camulative calculation. The problem is when you jump from April 1 to April 2, the camulative calculation starts over again. Does somebody know the solution to this problem?
See example.

Date	Transaction_id	Transactions	Camulative_calculation
01-april	1	50	50
01-april	2	-80	-30
01-april	3	210	180
02-april	4	80	80
02-april	5	50	130
02-april	6	100	230

Re: cumulative calculation DAX

tamerj1 — Thu, 08 Jun 2023 13:08:51 GMT

Hi Anonymous
Date is from which table? What happens if you remove it from the visual?

Re: cumulative calculation DAX

Anonymous — Thu, 08 Jun 2023 13:11:03 GMT

When i remove the Date column from the visual it works, but i need to include the date column.

Re: cumulative calculation DAX

tamerj1 — Thu, 08 Jun 2023 13:25:49 GMT

Anonymous
Please try

Cumulatieve Berekening = CALCULATE ( SUM ( 'Grootboekmutaties huidig jaar'[Saldo] ), FILTER ( ALLSELECTED ( 'Grootboekmutaties huidig jaar'[Omschrijving] ), 'Grootboekmutaties huidig jaar'[Omschrijving] <= MAX ( 'Grootboekmutaties huidig jaar'[Omschrijving] ) ), ALL ( 'Table'[Date] ) )

Re: cumulative calculation DAX

Anonymous — Fri, 09 Jun 2023 08:14:22 GMT

Thank you, this one works