Hello, everyone, I need your help. I have a data matrix with two columns where they contain start and end dates. I needed to know when we select a date this said it is within the time interval. An...
Hi henrydhs ,
Try using the following expression:
range = IF(MAX('Table'[StartTime]) <=MAX('Table 2'[Date]) && MAX('Table'[EndTime]) >= MIN('Table 2'[Date]),"within range","")
Best regards,
Community Support Team_ Scott Chang