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 "...
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.