Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Balaraju
Helper III
Helper III

Want to Extract new user and Old user in different features or column

Hi Guys.,

 I want to extract New user and Existing users based on User id and Month start date.  We have three features(columns) FB Access, FB Delete and FB Usage I need New user and Existing for all these three features values are showing below these columns are usage of the feature.

I want dax to extract for all the mentioned columns. below is the table attached to this query. 

Note: Also I want to extract new users based on previous year. i.e if the user have used the feature in 01-09-2021 and then he just uninstalled the app in that year . and later he tried to use it in 01-11-2022. then I want that user also to be consider as new user.

 

Balaraju_0-1643370224958.png

 

1 REPLY 1
amitchandak
Super User
Super User

@Balaraju , Usually this is how we do. We check duration is user has a record or not. and then compare with other duration and take the decision of new

refer these example. Current and last duration need to be as per need 

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.