If statement for columns in two tables

[Anonymous]

Hi experts, I can’t work out on how to create a calculated column using 2 columns from different tables.

I’m trying to create a calculated column using If statement:

Column "Amount" and column "currency code" is in table 1

Column "new currency code" is in table 2

Both tables are linked together on company ID column.

When creating column "Final currency code" in table 1 using condition as

= if ( Amount=0;  Currency code ; new currency code) ;  columns from second table is not shown up

There is a relationship between both tables .

Any ideas?

Thanks,

Neha.

[RajMalhotra1984]

Hi I have a similar situation but no solution-

I have 1324 equipment numbers in table 1 all are unique values.

Then I have 1174 equipment number in table 2 all are unique values.

These equipment numbers are connected in the relation table.

Table 2 has Hours of work in a coloumn for each equipment.

What I intend to do is create a custom coloumn in table 1 where I can bring the hours of work for each equipment from table 1 and then where ever we don't have hours available in table 2 (1324-1174 = 150 equipments will have no hours as they don't exist in table 2). I want the custom coloumns to show 0 hours for these 150 equipments. Can you help.

[Greg_Deckler · Accepted solution]

I believe you want:

Column = if ( [Amount]=0;  [Currency code] ; RELATED([new currency code])) ; 

Make sure that you are doing this in DAX and not Power Query. 

[Anonymous]

Thank You Greg !