Forum Discussion
Solved
Cumulative total not working
Hello, I'm facing an issue with my cumulative total that is surely related to the applied filters. I need to calculate the cumulative revenue and expenses by month and by client. I've used th...
At the end I figured it out, I needed to use the calendar table. Thus it allows me to filter by any client:
IMS_Revenue acumulado = CALCULATE([IMS_Revenue];filter(ALL(Calendario);Calendario[Date]<=MAX(Calendario[Date])))
Regards.
At the end I figured it out, I needed to use the calendar table. Thus it allows me to filter by any client:
IMS_Revenue acumulado = CALCULATE([IMS_Revenue];filter(ALL(Calendario);Calendario[Date]<=MAX(Calendario[Date])))
Regards.