Categorize total users based on existing and New customers in Dax

[Anonymous]

Hi,

I have a table like below with three columns. 

Date	Customer name	Total users
Jan-01	xyz	10
Jan-01	abc	30
Jan-01	eft	25
Feb-01	xyz	20
Feb-01	abc	30
Feb-01	eft	50
Feb-01	maf	5

Based on this table i am visualising user growth Mom as below

	Jan-01	Feb-01
user growth Mom	65	105

Now i want to enhance this report, by categorising the user growth by new and existing customers.

For example, from the above table customer "Maf" is the new customer added on Feb who added 5 users. for this i have to create two conditional columns. one should be the total users from existing customers and total users from new customers. so i can categorize the visual like below

		Feb-01
	users from existing customers	users from new customers
user growth Mom	100	5

Please help how we can create two conditional columns for user total of existing and new customers

[ribisht17]

Any luck with the provided solution?

Regards,

Ritesh

[Anonymous · Accepted solution]

@ribisht17 

Thanks for your solution. But i have tried an other calculation and it worked

[ribisht17]

Sure, good to know that, then you can paste your calculation here and set that as resolved so that it can help the community

Regards,

Riresh

[ribisht17]

Let me know if it helped you or not, if yes, please mark the answer so that it can help others as well

File was reuploaded 

Regards,

Ritesh

[ribisht17]

Are you able to download it now with the new link?

Regards,

Ritesh

[ribisht17]

https://drive.google.com/drive/folders/1RXVBOg-i46OMGZrgACeE_norA0XJiULS?usp=sharing

Regards,

Ritesh

Please mark the question if it helps you so that it can help others

[ribisht17]

https://drive.google.com/file/d/16Ex7B5uJiSl0-GCvEj4jH2vvDyoypz58/view?usp=sharing 

Regards,

Ritesh

Please mark the question if it helps you so that it can help others

[Anonymous]

Hi,

I am not able to open the file, could you please send as unzipped file please?

[ribisht17]

Hi Unipbi123,

Are you looking for something like this,

If yes, then this is the DAX for the same

Column = IF(

COUNTROWS(

FILTER(

'User Growth','User Growth'[Customer name]=EARLIER('User Growth'[Customer name])

)

)=1,"New","Old"

)

Regards,

Ritesh

Please mark the question if it helps you so that it can help others

[Anonymous]

Hi,

Can you share the pbix file with me please?