Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
User | Count |
---|---|
83 | |
77 | |
71 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |