cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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!!!!!!
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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 3
Anonymous
Not applicable

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

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

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.....

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors