Date in last 3 days

[Sdhn420]

Hi,

How can I check if the date in my calendar table falls within the last 3 days from today?

[PC2790]

Hi @Sdhn420 ,

A simple DAX column with the below formula will solve your purpose:

CheckifinLast3Days = if(Vaccination[Record Date] = TODAY()-3,"True","False")

I hope this helps. Appreciate your Kudos!

[Sdhn420]

Its giving me only 15th Jan. I am looking for 15th, 16th and 17th.

[amitchandak · Accepted solution]

@Sdhn420 , I think you need to minor change in suggested code

Last3Days = if(Table[Date] >= TODAY()-3 && Table[Date] <=today(),"True","False")

or

CheckifinLast3Days = if(Table[Date] >= TODAY()-3 && Table[Date] <today(),"True","False")

[Sdhn420]

Thank you!!