Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi, I'm struggling a lot with this problem, any help would be appreciated
I have a table like this:
A | B | C |
24 | 1 | 7 |
14 | 2 | 7 |
64 | 3 | 7 |
24 | 4 | 7 |
13 | 5 | 7 |
47 | 6 | 7 |
62 | 7 | 7 |
34 | 8 | 14 |
63 | 9 | 14 |
35 | 10 | 14 |
74 | 11 | 14 |
35 | 12 | 14 |
75 | 13 | 14 |
35 | 14 | 14 |
I want to create a new column such that:
If B != C for the row, then we want the value from A WHERE the C for the row in question = B from any of the rows.
Else if B == C, we wnat the value from A.
The resulting table looks like:
A | B | C | New column |
24 | 1 | 7 | 62 |
14 | 2 | 7 | 62 |
64 | 3 | 7 | 62 |
24 | 4 | 7 | 62 |
13 | 5 | 7 | 62 |
47 | 6 | 7 | 62 |
62 | 7 | 7 | 62 |
34 | 8 | 14 | 35 |
63 | 9 | 14 | 35 |
35 | 10 | 14 | 35 |
74 | 11 | 14 | 35 |
35 | 12 | 14 | 35 |
75 | 13 | 14 | 35 |
35 | 14 | 14 | 35 |
I have tried:
Solved! Go to Solution.
Hi,
Try this formula
New Column =
VAR a_val = 'Table'[A]
VAR b_val = 'Table'[B]
VAR c_val = 'Table'[C]
RETURN
IF (
b_val <> c_val,
LOOKUPVALUE( 'Table'[A], 'Table'[B], c_val),
a_val)
Hi,
Try this formula
New Column =
VAR a_val = 'Table'[A]
VAR b_val = 'Table'[B]
VAR c_val = 'Table'[C]
RETURN
IF (
b_val <> c_val,
LOOKUPVALUE( 'Table'[A], 'Table'[B], c_val),
a_val)
Thanks so much for your reply!!!
But I am getting this error for some reason:
"A table of multiple values was supplied where a single value was expected."
Look I think your formula is pretty sound - I'll go check my data to see if there are multiple matches between columns B and columns C.....
Thanks for your help!!!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |