Forum Discussion

Harvey85's avatar
Harvey85
Helper I
2 years ago
Solved

Getting Column from another table by applying filter

Hello everyone, I have the following query:   I have table A and table B. Between tables A and B, I have a common field as a key, called Camp_ID.   Table A is my main data table. From table B, I ...
General Comment
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    2 years ago

    Harvey85 , new column in table A

     

    Maxx(filter(TableB, Tablea[Camp_id] = tableB[campId] && containsstring(TableB[categoty], "Spring") ), TableB[Date])

amitchandak's avatar
amitchandak
Super User
2 years ago

Harvey85 , new column in table A

 

Maxx(filter(TableB, Tablea[Camp_id] = tableB[campId] && containsstring(TableB[categoty], "Spring") ), TableB[Date])

Harvey85's avatar
Harvey85
Helper I
2 years ago

Thanks amitchandak for your kind reply!

One more question, if I had a list of IDs to filter instead of Category=Spring... how could I do?

Let's say I'd need to filter ID_Category 1, 5, 7... To modify the formula?

Thanks in advance!!