Forum Discussion

capko's avatar
capko
Helper II
3 years ago

Check between two dates and two tables

Hello,   Let's say that I have two tables:   Table 1         | A | Date | |----|------------| | A1 | 01/02/2012 | | A1 | 03/04/2015 | | A2 | 04/03/2012 | | A5 | 25/07/2018 | | A1 | 0...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

capko Here's another approach in addition to Ahmedx 

Check = 
    VAR __A = MAX('Table'[A])
    VAR __Date = MAX('Table'[Date])
    VAR __Table = 
        ADDCOLUMNS(
            FILTER('Table2', [A] = __A),
            "__Check", IF(__Date >= [Date 1] && __Date <= [Date 2], 1, 0)
        )
    VAR __Result = IF(SUMX(__Table, [__Check]) > 0, 1, 0)
RETURN
    __Result