Forum Discussion
Add a new column
Hello
I have a dataset and want to dontscreens show. I want to add a new colum based on the combination of two that already exist.
3 Replies
Hi,
Does this calculated column formula work?
User = coalesce(Data[User1],Data[User2])
Tomasavlis not sure what you are trying to achieve. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Hi Tomasavlis ,
Based on the information you provided, do you want something like this? Extract the values of column 1 and column 2 that are not blank, and if the values of column 1 and column 2 are both not blank, then extract the value of column 1. If I understand correctly, then you can refer to Ashish_Mathur very good method. But here is a question, why is the result of the first row User instead of User1? Or is it just a spelling error that can be ignored?
Best regards,
Mengmeng Li
