Yearly Customer Historical Sales in DAX

With DAX you can calculate the sales of the first, second and third year of a new customer without any ETL. In this article you see how to implement this calculation with good performance. Consider the classical Adventure Works scenario. You want to see, for each Occupation, the total amount of sales made on the first three years, considering for each customer the date of the first order.As you see in the PivotTable below, Management and Professional are the two occupations that spends more in the second year, whereas Clerical and Manual occupations produce higher revenues in the third year.