cancel
Showing results for
Did you mean:
Helper I

## Calculated Column with IF and from different table

HI GUYS and GALS

is it poassable to add a column to a exsting table based on another table using a if statement

i.e

Table one

 Ref Status blah blah blah 1 A 1 5 2 A 1 5 3 R 2 5

Table 2

 Ref Stataus No status notes 1 1 Raised blah blah blah 1 2 Dispatched blah blah blah 1 3 Dilivered blah blah blah 2 1 Raised blah blah blah 2 2 Dispatched blah blah blah 3 99 Out of stock blah blah blah

Combined table

i only want notes when theres a problem (status 99) other wise blank

 Ref Status blah blah blah notes 1 G 1 5 2 A 1 5 3 99 2 5 blah blah blah
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support

## Re: Calculated Column with IF and from different table

Simply try LOOKUPVALUE Function.

```notes =
LOOKUPVALUE ( Table2[notes], Table2[Ref], Table1[Ref], Table2[Stataus No], 99 )
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Memorable Member

## Re: Calculated Column with IF and from different table

Hi @Sir_night,

Yes, its very much possible. Make sure you related the two tables before writing DAX to create a new column using IF statement.

Prateek Raina

Helper I

## Re: Calculated Column with IF and from different table

do you have any examples dax ?

Highlighted
Community Support

## Re: Calculated Column with IF and from different table

Simply try LOOKUPVALUE Function.

```notes =
LOOKUPVALUE ( Table2[notes], Table2[Ref], Table1[Ref], Table2[Stataus No], 99 )
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors