need something like VLOOKUP in Excel

[ansona]

Hello,

Im new learner in power BI, i got a question for adding column between 2 tables.

first picture of below is my table relationship, and second table is about i want to move the data from left table to right table.

if it is in excel, we can always set the formula VLOOKUP in right table.

appreaciate if anyone can teach me how to do this, thanks.

*this is my first time posting, let me know if the data im provide is not enough.

relationship of my tablethis is data of 2 tables

[BharathOddiraju · Accepted solution]

@ansona Once relationship is created between 2 tables, add a new column in second table using below dax

=Related(FirstTableName[ColumnName])

[Anonymous]

How do you get something like this to work if you have 2 date columns?   For instance - looking to lookup the year from a "submitted date" verses the "entered date".  Is there a formula which can be written to be more specific?  Thanks!

[Ashish_Mathur]

Hi @Anonymous,

Share a dataset and show the expected result.

[ansona]

Thank you very much, it works.

Been headache about this few days.