Getting Prior week sales in summarize table

[AwaisAnwar]

Hi, I need help. I am trying to find mark weekly status of customer if he is new customer, lost customer or restart customer. i am unable to find previous week sales before week in context to decide its a new customer or restart

[LufengYuan · Accepted solution]

Here is a similar data with yours. 

1. add a WeekNum column WeekNum = WEEKNUM('Table1'[dateExam])

2. then calculate previous week total number that is total sales in your case.

3. then use IF statement to flag the customers

Hope this is helpful for you.

[AwaisAnwar]

Thanks