Get Column from another table by applying filter

[Syndicate_Admin]

Hi 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, it's called Camp_ID.

Table A is my main table with data. From table B, I need to filter the rows where the Category field starts with 'Spring*' and get column End_Date from that table and take it to table A.

How can I go about filtering the data in Table B and bringing me to Table A in column End_Date? You wouldn't need to have table B in the model, it's just to get that field.

Thank you!!!

[amitchandak · Accepted solution]

@Syndicate_Admin ,new column in table A

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