Lookup Value Query

Thank you raji_n 

Hi, utsavlexmark 

Based on your description, I've created the following two tables:

table1:

table2:

Using the DAX expression you provided does bring up the problem you mentioned, as shown in the image below:

To do this, I've changed the expression to look like this, and I've matched the corresponding 'Table 2'[Unique Visitors (All sources)] with the month by URL:

Column 2 = LOOKUPVALUE(
		'Table 2'[Unique Visitors (All sources)],
		'Table 2'[URL],
		'Table 1'[URL],
		'Table 2'[Month],
		'Table 1'[Month],
		0
	)

I've provided the PBIX file used this time below.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.