- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Month over Month Difference in percentage of number of new clients.
Hello everyone,
I'm finding it difficult to create a measure to find the percentage between the difference of new clients every months.
Let's say I have two tables: a date table and a client table. The date table is the usual table with date key, year, month and day. The client table is a table that has a client id and the date he joined.
What I would like to do is a measure that allows me to see the growth percentage of clients each month.
I've tried to do this:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Month Difference in percentage.pbix

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Update on this topic.
I was able to do this by doing 4 measures:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
This article may help you to write the correct measure so as to solve your problem : https://www.daxpatterns.com/new-and-returning-customers/
If not, please consider to share some sample data and an expected output so we can help you better.
Best,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I don't think this helps since its not about the purchases. Is just when they joined.
To clarify it better what I have is basically a table with
clientid | joined
1 | 30/1/2020
2 | 30/1/2020
3 | 25/2/2020
4 | 25/3/2020
5 | 30/3/2020
What I would like to have is a table with.
Month | Growth
Jan | 100% (or zero)
Feb | -50% (since we have 50% less new joiners)
Mar | 50% (since we won 50% more new joiners in comparison to last month)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
For March, shouldn't the answer be 100%?
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You are correct!! My mistake!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
You may download my PBI file from here.
Hope this helps.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-29-2024 09:52 AM | |||
08-20-2024 06:17 PM | |||
08-20-2024 04:14 PM | |||
06-05-2024 02:43 AM | |||
11-08-2024 07:23 AM |
User | Count |
---|---|
137 | |
107 | |
84 | |
59 | |
46 |