Add a new column

[Tomasavlis]

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. 

[Anonymous]

Hi @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

[Ashish_Mathur]

Hi,

Does this calculated column formula work?

User = coalesce(Data[User1],Data[User2])

[parry2k]

@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/38490