Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Community,
I want to create a column with the values of Column 1 and Column 2 as column 3,
How can I achieve this, kindly help
Column 1 | Column 2 | Column 3 |
A | 0 | A |
B | 0 | B |
0 | C | C |
0 | 0 | 0 |
0 | D | D |
Regards
Prabhu
Solved! Go to Solution.
Oh okay, my bad!
here is a solution to that:
Hi,
By combining, do you mean concatinating?
Then you can use:
Hi, I don't need to concatenate, I trying to achieve through the condition
i.e If Column 2 has value then return the value of Column 2 else return the value of Column 1 in the final Column 3
Oh okay, my bad!
here is a solution to that: