Search for categories between two tables

[JeroenN]

I have two tables. Table A contains the rent of houses. Table 2 shows the limit values for the rental classes. 

Now I want to add the rental classes to table 1.

So in my example, house 1 falls in Group 4 and house 2 falls in Group2

In Excel this is easily done with the match-function. 

How can I do this in Power BI?

A	House	Rent
	1	602
	2	500
	3	975
	4	650
	5	524

B	Group	RentMax
	Group1	400
	Group2	500
	Group3	600
	Group4	700

Hope you can help me on this!

[Greg_Deckler]

Rent Group = VAR MaxRent = MINX(FILTER(RentGroups,RentGroups[RentMax]>=MAX(Houses[Rent])),RentGroups[RentMax])
RETURN LOOKUPVALUE(RentGroups[Group],RentGroups[RentMax],MaxRent)

Nice job with posting the data and what you expect as a result.

[JeroenN · Accepted solution]

Thanks Greg!

With one little adjudgment it works perfectly:

Rent Group = VAR MaxRent = MINX(FILTER(RentGroups,RentGroups[RentMax]>=(Houses[Rent])),RentGroups[RentMax])
RETURN LOOKUPVALUE(RentGroups[Group],RentGroups[RentMax],MaxRent)