Forum Discussion
Post ProdigyCount new Customers per Week
I have a table that lists all customer IDs on a daily basis. Every day is a snapshot done of the table.
| Customer ID | Snapshot Date | Value | Type |
| AAA1 | 01.01.2020 | 50 | A |
| AAA2 | 01.01.2020 | 50 | A |
| AAA1 | 02.01.2020 | 50 | A |
| AAA3 | 02.01.2020 | 50 | A |
This table is linked to the calendar table and to a country table based on the Customer ID.
Now I would like to determine how many new customers we have now compared to the previous week.
Therefore I need somehow the total unique customers for the previous week against the total unique customers this week.
How would you do that?
1 Reply
- amitchandak
Super User
joshua1990 , How work on this week vs last week
refer
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8In this blog Use this week vs last week in place of month for new customer
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
