Current query cannot be evaluated ... because the table contains more than two billion rows

Anonymous , Lookup is a costly operation, what are you trying to achieve here. explain with an example and some sample data.

Can you share small sample data and sample output in table format? Or a sample pbix after removing sensitive data.