Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
@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
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
Is there a way to do this in dax?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
106 | |
87 | |
77 | |
69 |
User | Count |
---|---|
123 | |
112 | |
95 | |
83 | |
73 |