Hi, I'm struggling a lot with this problem, any help would be appreciated I have a table like this:ABC24171427643724471357476762773481463914351014741114351214751314351414I 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:ABCNew column241762142762643762244762135762476762627762348143563914353510143574111435351214357513143535141435 I have tried:Weekend inventory = if([B]<>[C],SELECTCOLUMNS(filter(Table,[B]=[C]),"temp",[A]),[A]) But this gives me an error which I assume is because there are multiple matching B and C values... Any help would be really appreciated!!!!!!

Hi, Try this formulaNew 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)

Anonymous

Not applicable

6 years ago

Solved

Creating new column using values from column A, conditional on columns B and C

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:

Weekend inventory = if(

[B]<>[C],SELECTCOLUMNS(filter(Table,[B]=[C]),"temp",[A]),

[A])

But this gives me an error which I assume is because there are multiple matching B and C values...

Any help would be really appreciated!!!!!!

Need Help

Anonymous

6 years ago

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)

3 Replies

Anonymous
Not applicable
6 years ago
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)
- Anonymous
  Not applicable
  6 years ago
  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."
  - Anonymous
    Not applicable
    6 years ago
    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!!!

Forum Discussion

Creating new column using values from column A, conditional on columns B and C

3 Replies

Related content

Create measure to return value from column when condition met for two other columns

Create conditional index column

Create columns group

Conditional Column with Multiple Conditions

Create Conditional Column Based Upon Two Other Columns

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

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

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