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 ,
Based on your description, I did simple samples to get the following results:
Table 2 = CALENDAR(MIN('Table'[StartTime]),MAX('Table'[EndTime]))
range = IF(AND(SELECTEDVALUE('Table 2'[Date])>=MAX('Table'[StartTime]),SELECTEDVALUE('Table 2'[Date])<=MAX('Table'[EndTime])),"within range","")
Best regards,
Community Support Team_ Scott Chang