The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |