child objects
1 TopicCalculate column with TRUE or FALSE values, according to values held in parent AND child table
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...Solved1KViews0likes2Comments
