Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Conditional Column in DirectQuery

What is the best way to create a conditional column in direct query with multiple conditions. I would like the condition to state the following.

 

If Original Column = A then T, else if Original Column = B then U, else if Original Column = C then V, else if Original Column = D then W. If none of the criteria is met then return Original Column.

 

See the table below for output

 

Original Column      New Column    
AT
BU
CV
DW
EE
FF
GG
HH
II
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Anonymous 

    In Power BI desktop, please create a calculated column and paste the below DAX (update the dax as per your requirement)

     

    New Column = SWITCH(
    TRUE(),
    'Table'[Original Column] IN {"A"},"T",
'Table'[Original Column] IN {"B"},"U",
'Table'[Original Column] IN {"C"},"V",
'Table'[Original Column])

     

     


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

1 Reply

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Anonymous 

    In Power BI desktop, please create a calculated column and paste the below DAX (update the dax as per your requirement)

     

    New Column = SWITCH(
    TRUE(),
    'Table'[Original Column] IN {"A"},"T",
'Table'[Original Column] IN {"B"},"U",
'Table'[Original Column] IN {"C"},"V",
'Table'[Original Column])

     

     


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin