conditional column for different entity

[manishsalanke]

hi , community we have a conditon in which we need to create a calulated column using dax for vendor ,agent ,party .we have to create a bucket for agent ,party and agentFor party we have this list

for vendors we have this list

for agent we have this

 need to create a calculated column containg agent ,vendor, party

[tamerj1]

Hi @manishsalanke 
The requirement is not clear. Perhaps you can clarify further with examples.

[manishsalanke]

actully we have one column which contains names and now we need to create a new column which contains values for party ,vendor ,agentThis column we have and we have to group few values as agent ,other for vendors and remaing party

this is how we want to see it in other column

[tamerj1 · Accepted solution]

@manishsalanke 
I Suppose you have that column in the main table and you have 3 lists (vendor ,agent ,party) in 3 separate tables. As follows:
'Table'[Column]
Vendors[Vendor]
Agents[Agent]
Parties[Party]

The new column would be

NewColumn =
SWITCH (
    TRUE (),
    'Table'[Column] IN VALUES ( Agents[Agent] ), "Agent",
    'Table'[Column] IN VALUES ( Vendors[Vendor] ), "Vendor",
    'Table'[Column] IN VALUES ( Parties[Party] ), "Party"
)