Forum Discussion
Custom Column that returns value from another column
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...
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
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