Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@ansona Once relationship is created between 2 tables, add a new column in second table using below dax
=Related(FirstTableName[ColumnName])
@ansona Once relationship is created between 2 tables, add a new column in second table using below dax
=Related(FirstTableName[ColumnName])
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!
Hi @Anonymous,
Share a dataset and show the expected result.
Thank you very much, it works.
Been headache about this few days.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |