Forum Discussion
Cumulative Total
Hi,
I am really struggling to get my montly sales to cumulative total. I have tried numerous DAX and varations on date tables but still cannot get the data to count cumulatively.
In order to calculate my YTD total sales i have created a DAX as below to filter the relevant rows.
Total All Sales YTD = CALCULATE(SUM('Sheet (2)'[Total Sell]), FILTER('Sheet (2)', 'Sheet (2)'[Status] = "S"), filter('Sheet (2)', 'Sheet (2)'[Total Cost]>100))
Could this be affecting my results?
Below is how the data looks if i put it into a table
Power BI appears to have already created a date table from my "Invoice Date" column.
IS there a simple DAX that can count each months sales to create a cumulative total againt month?
Thanks in advance!
4 Replies
Refer this
https://community.powerbi.com/t5/Desktop/Cumulative-Total/m-p/43115
https://community.powerbi.com/t5/Desktop/Cumulative-Total/m-p/857660
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.Thanks Anonymous
I have seen those posts and this is the result i get.
A side from the values being wrong (because i need to add some filters) they are still not adding cumulatively?
