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.
Hello everyone,
Can anybody help me with this? I am trying to understand how many active and inactive users in our system. We can track the status of the user based on his activity.
If he created a record within a 3-month window thus he is active.
Example:
User | Transaction Date | Date Dimension | Status |
A | 01/01/2019 | January | Active |
A | 01/01/2019 | February | Active |
A | 01/01/2019 | March | Active |
A | 01/01/2019 | April | Inactive |
A | 01/01/2019 | May | Inactive |
A | 06/01/2019 | June | Active |
A | 06/01/2019 | July | Active |
A | 06/01/2019 | August | Active |
A | 06/02/2019 | September | Inactive |
Hi ogureisuo,
I am not clear about your requirement, so if possible, could you please inform me more detailed information (such as your expected output)? Could you please explain your logic based on above sample and inform me your expected output, then I will help you more correctly.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |