Forum Discussion

Sir_night's avatar
Sir_night
Frequent Visitor
9 years ago
Solved

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                                                             ...
Need Help
prateekraina's avatar
prateekraina
Memorable Member
9 years ago

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's avatar
Sir_night
Frequent Visitor
9 years ago

hi prateekraina 

 

do you have any examples dax ?

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    9 years ago

    Sir_night,

     

    Simply try LOOKUPVALUE Function.

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