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 "100 Thieves" for that same row.
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
3 Replies
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
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 resPlease 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