I’m looking to find out what a customer spends in the first 1, 3, 6 and 12 months after their first order. I have created a calculated column within the customer table to find out what the first order date is (First Order Date = MIN(Orders[Order Date]). Now I’m struggling how to write the DAX to work out the future sales from this date.
I need to create a calculation which uses the first order date then calculates the total sales for one month after the first order date, then 3 months, 6 and 12.
Any assistance would be greatly appreciated