populate values from another table to new column on custom table

Create a new column in table 1 like

column 3 =minx(filter(table2,table1[column1]=table2[column1] && table2[column2] =table1[column2]),table2[value])

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

Hi Dee ，

Go to "edit queries">"Add column">"Index column">"from 1",

Then back to "data view " and create a measure as below:

Measure = 
var a =
CALCULATE(MIN('Table'[Index]),ALLEXCEPT('Table','Table'[column2]))
return 
IF(SELECTEDVALUE('Table'[Index])=a,SELECTEDVALUE('Table'[value]),0)

Or you can add a calculated column：

Column 2 = 
var a =
CALCULATE(MIN('Table'[Index]),ALLEXCEPT('Table','Table'[column2]))
return 
IF('Table'[Index]=a,VALUE('Table'[value]),0)

Finally you will see :

For the related .pbix file,pls click here.

 
Best Regards,
Kelly