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,
I Have a table of users with their status, involving either active or inactive. Picture 1
Date | Status | Status Text | User |
03-Mar | 0 | Active | A |
04-Mar | 1 | Inactive | A |
03-Mar | 0 | Active | B |
04-Mar | 0 | Active | C |
05-Mar | 1 | Inactive | C |
05-Mar | 0 | Active | D |
I want to create a graph that shows the number of users who have changed from active to inactive or vice versa.
For example, in this case, the number of users is 2. (Users A and C). In fact, users B and d didn't change and should not be counted.
Is there a way to have a calculated column or measure to solve that?
Best,
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |