Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |