Forum Discussion

manishsalanke's avatar
manishsalanke
Helper II
3 years ago
Solved

conditional column for different entity

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

"beginner asks Help"
"Need Help"
  • tamerj1's avatar
    tamerj1
    3 years ago

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

     

3 Replies

    • manishsalanke's avatar
      manishsalanke
      Helper II
      3 years ago

      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's avatar
        tamerj1
        Community Champion
        3 years ago

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