Forum Discussion
Solved
Total Customers By Year
I'm trying to find the number of customers by year. The graph shows how many customers that started service in that year (red line). What I need is for the previous year values to add up each year so...
SOLVED!
Added a column to the table on the Data View tab (on the left hand side of the screen). The formula is
Cumulative Customers = CALCULATE(SUM('Cumulative Customers'[Total Customers]),FILTER('Cumulative Customers','Cumulative Customers'[Year]<=EARLIER('Cumulative Customers'[Year])))
SOLVED!
Added a column to the table on the Data View tab (on the left hand side of the screen). The formula is
Cumulative Customers = CALCULATE(SUM('Cumulative Customers'[Total Customers]),FILTER('Cumulative Customers','Cumulative Customers'[Year]<=EARLIER('Cumulative Customers'[Year])))