Forum Discussion
If statement for columns in two tables
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.
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.
3 Replies
- Greg_Deckler
Community Champion
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.
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.
