Forum Discussion
Merging data from one table to another
Hello - I have 2 tables in my model that I am trying to 'merge' the data together. I am looking to pull one data element from Table1 and put it in Table2. The two tables have a relationship ba...
If the tables are not linked with the relationship then you can use below method
LOOKUPVALUE = LOOKUPVALUE(Table2[Approval Date],Table2[Transaction ID],Table1[Transaction ID])
Hope this helps :smileyhappy:
Use the function Related = RELATED(Table2[Approval Date])
Hope this helps :smileyhappy:
Hey Kasunpathirana I cannot get this to work because the relationship between the 2 tables is not active. Power BI will not let me make it active due to both tables being joined to the Calendar table.
If the tables are not linked with the relationship then you can use below method
LOOKUPVALUE = LOOKUPVALUE(Table2[Approval Date],Table2[Transaction ID],Table1[Transaction ID])
Hope this helps :smileyhappy: