cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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:

Last Month Clients = CALCULATE(COUNT(FactClient[id]), PARALLELPERIOD(FactClient[joined], -1, MONTH))

And then the idea was to just divide this over the total number of clients, but not even this formula is working.

Any ideas on how to implement this?

7 REPLIES 7
Super User

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

Anonymous
Not applicable

Update on this topic.

I was able to do this by doing 4 measures:

lm_total_clients = COUNT(FactClient[id])
lm_lm_tickets = CALCULATE([lm_total_tickets],PARALLELPERIOD(DimDate[DateKey].[Date],-1,MONTH))
lm_variance = [lm_total_tickets]-[lm_lm_tickets]
lm_percentage = DIVIDE([lm_variance],[lm_lm_tickets],0)

The problem is that this only works for tables or graphs.
I would like to obtain a card value, and that I can't do.
Super User

Hi @Anonymous ,

If not, please consider to share some sample data and an expected output so we can help you better.

Best,

Anonymous
Not applicable

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)

Super User

Hi,

For March, shouldn't the answer be 100%?

Regards,
Ashish Mathur
http://www.ashishmathur.com
Anonymous
Not applicable

You are correct!! My mistake!!

Super User

Hi,

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors