Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am looking to create a column that categorizes each group based on the result of multiple columns.
A: IPC = No; Client = A
B: IPC = No; Client = B
Mixed: IPC = No; Client = A and B
IPC: IPC = Yes; Client = A
IPC Mixed: IPC = Yes; Client = B
It seems simple but has left me stumped. Any help is greatly appreciated.
Data Example:
Group | ID | IPC | Client | Desired Result |
1 | 123 | No | A | Mixed |
1 | 456 | No | B | Mixed |
1 | 789 | No | B | Mixed |
2 | 987 | Yes | A | IPC Mixed |
2 | 654 | Yes | A | IPC Mixed |
2 | 321 | No | B | IPC Mixed |
3 | 903 | No | A | A |
3 | 284 | No | A | A |
3 | 842 | No | A | A |
Solved! Go to Solution.
you can try this
Proud to be a Super User!
you can try this
Proud to be a Super User!
Hi,
Create a new column:
Category =
SWITCH(
TRUE(),
'Table'[IPC] = "No" && 'Table'[Client] = "A", "A",
'Table'[IPC] = "No" && 'Table'[Client] = "B", "B",
'Table'[IPC] = "No" && 'Table'[Client] IN {"A", "B"}, "Mixed",
'Table'[IPC] = "Yes" && 'Table'[Client] = "A", "IPC",
'Table'[IPC] = "Yes" && 'Table'[Client] = "B", "IPC Mixed",
BLANK()
)
Proud to be a Super User! | |
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
108 | |
92 | |
67 |
User | Count |
---|---|
161 | |
129 | |
129 | |
92 | |
91 |