Date greater then 10 days

[Invesco]

Hi Experts

How do you find where the date is greater then 10 days (based on the below) image and column status says open to in table ABC

[Tahreem24]

@Invesco How do you compare date column with 10 days. Please share the proper requirement with input and expected data.

[Invesco]

Apologies - here is my formula

Investigate = IF(AND(dev_meet_meeting_data[Start_Time] < TODAY() + 10,dev_meet_meeting_data[meeting_status] = "Ready for closure"),1,0). 

If from todays date less the Start_time Date is greater then 10 and meeting status is as above then 1 else 0...

not sure if the above is correct

[amitchandak · Accepted solution]

@Invesco , Based on today or the selected date

Based on today toy can have column flag

flag = if([Date] > today() +10, 1, 0)

for measure you can use count measure and use that in the visual or visual level filter

countrows(filter(Table, Table[Date] > today() +10) )