Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
Need help to count cumulative for total. However, i dont have the figure in excel. Im using the function to count the row. Issit possible to create a DAX formulae?
Yes, it is possible to create a DAX formula to count cumulative totals in Power BI. You can use the following formula:
Cumulative Total = CALCULATE(SUM(Table[Value]), FILTER(ALLSELECTED(Table), Table[Date] <= MAX(Table[Date])))
Replace "Table" with the name of your table and "Value" with the name of the column you want to calculate the cumulative total for. Also, replace "Date" with the name of the column containing the date information. This formula will give you the cumulative total for the selected period of time.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 15 | |
| 8 | |
| 8 | |
| 8 |