Re: Add a new column

Tomasavlis · ‎02-25-2025

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 · ‎02-26-2025

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 · ‎02-25-2025

Hi,

Does this calculated column formula work?

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

parry2k · ‎02-25-2025

@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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.