Forum Discussion
Help merging two financial tables?
In the screenshot above, I have Project Titles and the "Amount" Column coming from one table. These Projects are linked via an authorization number to financial tables coming out of an ERP.....
@RichardJ Thank you! The "Related" function worked.
RichardJ
Responsive Resident
Responsive ResidentHi Anonymous,
It's difficult to determine the reason without having access to the pbix file but another option to find the matching values is to delete the relationship which isn't providing the correct information and use LOOKUPVALUE to find the matching value from another table.
This video provides a good explanation of how it works
Also, further explanation can be found here:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Hope this helps,
Richard
@RichardJ Thank you! The "Related" function worked.