Custom Column that returns value from another column

[Anonymous]

Column "Team" has two unique values. I want to create a custom column that returns the value that is not present in that row. For example, for rows that contain "TSM", I want another column to return "100 Thieves" for that same row.

[AlB · Accepted solution]

@Anonymous 

Sure. Create a new calculated column:

New col =
VAR currentTeam_ = Table1[team]
RETURN
    CALCULATE ( DISTINCT ( Table1[Team] ), Table1[Team] <> currentTeam_ , ALL(Table1))

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlB]

Hi @Anonymous 

in the advanced editor, add a couple of steps like this at the end of your query (Assumes you have only two different values in [team] as you say):

values = List.Distinct(#"YourLastStep"[team]),
res = Table.AddColumn(#"YourLastStep", each if [team] = values_{0} then values_{1} else values_{0})
in
    res 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

Is there a way to do this in dax?