Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 , 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...
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |