Forum Discussion

JeroenN's avatar
JeroenN
Advocate I
8 years ago
Solved

Search for categories between two tables

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 G...
Tips and Tricks
  • JeroenN's avatar
    JeroenN
    8 years ago

    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)

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago
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's avatar
JeroenN
Advocate I
8 years ago

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)