Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
A | T |
B | U |
C | V |
D | W |
E | E |
F | F |
G | G |
H | H |
I | I |
Solved! Go to Solution.
Hi @dwhittaker1
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
Hi @dwhittaker1
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
User | Count |
---|---|
93 | |
85 | |
76 | |
67 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |