Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
Thank You Greg !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |