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,
This will likely be a very simple answer but I'm hitting a wall for some reason.
Essentially, If the client ID has a certin activity against it, I need a True or false/1 or 0 next to the entire client record. For exmple, see the table below.
Activites
client ID | activity |
1 | a |
1 | b |
1 | c |
2 | a |
2 | a |
2 | a |
3 | a |
3 | b |
3 | b |
4 | c |
4 | c |
4 | c |
I need to add a colum that identifies all clients who had NOT had activity C.
result
Clinet ID | activity | new |
1 | a | 0 |
1 | b | 0 |
1 | c | 0 |
2 | a | 1 |
2 | a | 1 |
2 | a | 1 |
3 | a | 1 |
3 | b | 1 |
3 | b | 1 |
4 | c | 0 |
4 | c | 0 |
4 | c | 0 |
As client 1 and 4 have both had Activity C, all their records needs to be False or 0.
Ideally, this needs to be completed in DAX.
Thanks in Advanced.
Edit/note
Client ID on my actual table is Alphanumeric.
Solved! Go to Solution.
@Anonymous For a measure try this:
For a calculated column try this:
PBI file is attached below my signature.
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 |
---|---|
54 | |
25 | |
23 | |
15 | |
11 |
User | Count |
---|---|
77 | |
61 | |
47 | |
18 | |
12 |