Forum Discussion
POWER BI DESKTOP
Hi All,
I am trying to write a query to get Result table as shown below. Column 1 and Column 2 are the inputs and "Result" is the output.
Can anyone help me on this:
| Table | Column 1 | Column 2 | Result |
| 1 | DEF | DEF | |
| 2 | ABC | GHI | ABC |
| 3 | JKL | JKL |
Hi Pooja,
You can get with the below dax.
Result = IF(SELECTEDVALUE('Table'[Column 1])<>BLANK(),SELECTEDVALUE('Table'[Column 1]),SELECTEDVALUE('Table'[Column 2]))Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂Regards,
N V Durga Prasad
2 Replies
nvprasadSolution Sage
Hi Pooja,
You can get with the below dax.
Result = IF(SELECTEDVALUE('Table'[Column 1])<>BLANK(),SELECTEDVALUE('Table'[Column 1]),SELECTEDVALUE('Table'[Column 2]))Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂Regards,
N V Durga Prasad