DAX to write a new column that takes value from two different tables

[ukanafun]

Hi All,

I am creating a new column in DAX and the values comes from two tables. However when I write this, It only shows the selected table and no bring errors in the other table as there is no suggestion to that table. There is a relationship between this two tables so that is not the issue. Example: Column = IF(TableB[status]="Good", 1900, IF(TableA[Year]=[Year_Cal], TableA[Year], BLANK()))

TableA will not be suggested if I am on TableB and vice versa and will have the red underline wehn creating the DAX and so the DAX will not work

[JirkaZ · Accepted solution]

You'll have to use RELATED() function to reach out to the second table