Dax Cumulative formula typically involves creating calculations that accumulate values over time, such as running totals or cumulative sums.
Cumulative Total =
CALCULATE(
SUM([Sales]),
FILTER(
ALLSELECTED('DateTable'),
'DateTable'[Date] <= MAX('DateTable'[Date])))
Subscribe to our email newsletter to get the latest posts delivered right to your email.
Comments