Calculate column with TRUE or FALSE values, according to values held in parent AND child table

[RichHead1821]

Table 1 has ID and a date, and in this table I want to add a calculated column.
Table 2 is a child of table 1 (FK is table1.ID), has its own ID and has a text column. 

The calculated column is to be TRUE or FALSE according to the value of table1.date (>= 01/10/2021 & <= 30/11/2021) AND whether table2.text has values of "VALUE A" OR "VALUE B".
I've tried IF with LOOKUPVALUE etc... and get the (expected) "A table of multiple values was supplied where a single value was expected" error.

I cannot fathom which DAX function to use for this...

[RichHead1821]

Perfect, thank you sir, also able to follow and understand.

[amitchandak · Accepted solution]

@RichHead1821 , If you need a new column in table A

New column =

var _cnt = countx(filter(TableB, TableB[value] in {"VALUE A" , "VALUE B"}), [Value]) +0

return

if(_cnt >0 && Table1[Date] >= date(2021,10,01) && Table1[Date] <= date(2021,11,30), true(), false() )