Create key out of two tables

[TomBrilliant]

I want to look up the value Historie in the table Historie, by looking for the combination of customer No and Article No. This value exists in the table Historie, but I need to find it in the table I created in PowerBI. 

[TomBrilliant]

this does not work since i do not have a value to look for

[PijushRoy]

Hi @TomBrilliant 

You can use LOOKUPVALUE https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax 

If not solve your requirement, please share sample data or pbix file, Image for your data model, and the expected result you are looking for. 

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS