Calculated Column with IF and from different table

[Sir_night]

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

[prateekraina]

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

[Sir_night]

hi prateekraina 

do you have any examples dax ?

[v-chuncz-msft · Accepted solution]

@Sir_night,

Simply try LOOKUPVALUE Function.

notes =
LOOKUPVALUE ( Table2[notes], Table2[Ref], Table1[Ref], Table2[Stataus No], 99 )