CUSTOM COLOUMN BASED ON TWO TABLES IN POWER BI

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

[HassanAshas]

Can you share sample Data from both these tables? and an expected output of the custom column you want in Table 1? 

From what I understood, you have two columns like these, 

Table 1

Table 2

Now you want the Hours from Table_2 to be transferred to the Table_1. 

There are two ways you can accomplish this,

First: If the tables are related (that is, you have a relation between them in your Data Model), then you can simply use the following DAX for your Custom Column in Table 1, 

Hours = RELATED(Table_2[Hours])

If you want "0" instead of BLANK, then use this, 

Hours = 
var __Hours = RELATED(Table_2[Hours])

RETURN 
    IF(
        ISBLANK(__Hours), 
        0, 
        __Hours
    )

Second Solution: If your tables are not related, then you can use LookUpValue (for this however, the Equipment_ID must be unique)

Hours = 

var __Hours = LOOKUPVALUE(Table_2[Hours], Table_2[Equipment_ID], Table_1[Equipment_ID])

RETURN 
    IF(
        ISBLANK(__Hours), 
        0, 
        __Hours
    )

This will give you the final output in Table_1 like this,