Forum Discussion
ansona
10 years agoRegular Visitor
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 le...
- 10 years ago
ansona Once relationship is created between 2 tables, add a new column in second table using below dax
=Related(FirstTableName[ColumnName])
BharathOddiraju
10 years agoMicrosoft Employee
ansona Once relationship is created between 2 tables, add a new column in second table using below dax
=Related(FirstTableName[ColumnName])
- ansona10 years agoRegular Visitor
Thank you very much, it works.
Been headache about this few days.
- Anonymous8 years agoNot applicable
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_Mathur8 years agoSuper User
Hi Anonymous,
Share a dataset and show the expected result.