Forum Discussion

ansona's avatar
ansona
Regular Visitor
10 years ago
Solved

need something like VLOOKUP in Excel

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

Need Help
  • BharathOddiraju's avatar
    BharathOddiraju
    10 years ago

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

    =Related(FirstTableName[ColumnName])

4 Replies

  • BharathOddiraju's avatar
    BharathOddiraju
    Microsoft Employee
    10 years ago

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

    =Related(FirstTableName[ColumnName])

    • ansona's avatar
      ansona
      Regular Visitor
      10 years ago

      Thank you very much, it works.

      Been headache about this few days.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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!