Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
@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] )
)
Hi @Anonymous
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.
@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] )
)
Thank you, this one works
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
41 | |
36 | |
22 | |
21 | |
20 |