Select value of ColumnA where ColumnB equals...

[Anonymous]

Hi

I'm struggling to find a way to achieve this requirement, but I'm convinced there must be a way to do it without making a whole new table.

Here is my data:

Event    UserName

[AC]      

[OP]      Bob

[OC]      Bob

[VC]      

[OP]      Bob

I want to create a new column that is a copy of the UserName column but only where the Event = "[OP]"

for example: NewColumn = UserName WHERE Event = "[OP]"

Desired Result

Event    UserName    NewColumn

[AC]      

[OP]      Bob               Bob

[OC]      Bob

[VC]      

[OP]      Bob               Bob

How could I write this in DAX?

[Anonymous · Accepted solution]

@Anonymous Have you tried using if function?

if(EVENT="[OP]";USERNAME;"none")