Forum Discussion
Solved
Add Custom Column with condutions of dublicate value
Hello,
My Data has the columns named "Issue ID" and "Brand". I want to add column to data named " Brand Overlapping" for the conditions below:
1-) If a Issue ID has both of Brand A and Brand B then Brand Overlapping = A & B Together
2-) If a Issue ID has only Brand A then Brand Overlapping = Only A
3-) If a Issue ID has only Brand B then Brand Overlapping = Only B
How can I add this column?
Appricate if you help for this issue 😞
| Issue Id | Brand | Brand Overlapping |
| 1 | A | A & B Together |
| 1 | C | A & B Together |
| 1 | B | A & B Together |
| 2 | A | Only A |
| 2 | A | Only A |
| 3 | B | Only B |
| 3 | C | Only B |
| 4 | A | A & B Together |
| 4 | B | A & B Together |
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column.
Brand Overlapping CC = VAR _issue = Data[Issue Id] VAR _t = FILTER ( Data, Data[Issue Id] = _issue ) RETURN SWITCH ( TRUE (), COUNTROWS ( FILTER ( _t, Data[Brand] = "A" ) ) >= 1 && COUNTROWS ( FILTER ( _t, Data[Brand] = "B" ) ) = BLANK (), "Only A", COUNTROWS ( FILTER ( _t, Data[Brand] = "A" ) ) = BLANK () && COUNTROWS ( FILTER ( _t, Data[Brand] = "B" ) ) >= 1, "Only B", COUNTROWS ( FILTER ( _t, Data[Brand] = "A" ) ) >= 1 && COUNTROWS ( FILTER ( _t, Data[Brand] = "B" ) ) >= 1, "A & B Together" )
3 Replies
- ThxAlot
Super User
- Jihwan_Kim
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column.
Brand Overlapping CC = VAR _issue = Data[Issue Id] VAR _t = FILTER ( Data, Data[Issue Id] = _issue ) RETURN SWITCH ( TRUE (), COUNTROWS ( FILTER ( _t, Data[Brand] = "A" ) ) >= 1 && COUNTROWS ( FILTER ( _t, Data[Brand] = "B" ) ) = BLANK (), "Only A", COUNTROWS ( FILTER ( _t, Data[Brand] = "A" ) ) = BLANK () && COUNTROWS ( FILTER ( _t, Data[Brand] = "B" ) ) >= 1, "Only B", COUNTROWS ( FILTER ( _t, Data[Brand] = "A" ) ) >= 1 && COUNTROWS ( FILTER ( _t, Data[Brand] = "B" ) ) >= 1, "A & B Together" ) Hi,
It works perfectly. I'm appreciate very much. Thank you 🙏
