Replace if criteria is met in another column

[Comphez]

Hello everybody,
I have 2 columns in my file, column 1 contains "IDs" and column 2 "Names".
What I'm trying to tell the software is something like this:
If you find these different "IDs" in column 1 then replace with this "Name" in column 2.
I searched looking for a solution to this simple problem, but I wasn't able to find one 😞

[v-haibl-msft · Accepted solution]

@Comphez

You can also try to create a new column with DAX formula as below.

 

Best Regards,

Herbert

[Habib]

You can achieve this using below steps

1. Add a new column and provide conditions that what you want to replace with your conditions will be like this
2. Click on Conditional Column option
3. Go to Edit Queries and move to "Add Column" Tab
4. If IDs = ???? then new column = ??   else new column = Name
5. Once you get new column with required results, you should hide Name column and should replace new column to Name

Please refer to below image for details on Conditional Column