Forum Discussion
Solved
Getting Prior week sales in summarize table
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 ...
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.
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.
Thanks
