topic conditional column for different entity in DAX Commands and Tips

conditional column for different entity

manishsalanke — Thu, 30 Mar 2023 05:25:42 GMT

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 agent

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

Re: conditional column for different entity

tamerj1 — Thu, 30 Mar 2023 06:30:12 GMT

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

Re: conditional column for different entity

manishsalanke — Thu, 30 Mar 2023 06:54:37 GMT

actully we have one column which contains names and now we need to create a new column which contains values for party ,vendor ,agent

Re: conditional column for different entity

tamerj1 — Thu, 30 Mar 2023 08:36:17 GMT

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" )