I made a DAX formula for camulative calculations.
See dax formula
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 |
Solved! Go to Solution.
@HuubKW
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] )
)
Hi @HuubKW
Date is from which table? What happens if you remove it from the visual?
When i remove the Date column from the visual it works, but i need to include the date column.
@HuubKW
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] )
)
Thank you, this one works
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!