Latest Enterprise DNA Initiatives

Evaluating New Customer Sales - Advanced Analytics in Power BI

Please see the above video to learn more. To ask any questions on the content covered in this tutorial please start a new topic within the forum. You may check this how-to guide for reference - How To Use The Enterprise DNA Support Forum

I am new to this forum.
Trying ti get help on the customer churning / New customers.

I am trying to identify new customers that haven’t had any sales in 90 days and then graph their sales my month.
So in the data customer C1000 is identified as a new customer on the 4-1-17 now I want to graph their sales moving forward.

Not sure how I do that

I can create a measure to find the new customer but how do I calculate total sales from there on.
new customers sales clay =
VAR CustomerTM = VALUES(Sales[Customer ID])
VAR PriorCustomers = CALCULATETABLE(VALUES(Sales[Customer ID]),
FILTER(ALL(Dates),
Dates[Date] > MIN(Dates[Date]) - 90 &&
Dates[Date] < MIN(Dates[Date] )))

Return
CALCULATE([Total Sales],
EXCEPT(CustomerTM,PriorCustomers)
)

Thanks