Not Today - In Records

[andrewb95]

I want to show all records which record a date which is not the current day. 

Ie. I have 5 records [Today is 12.11.2020]

1. 12.11.2020
2. 12.11.2020
3. 10.11.2020
4. 09.11.2020
5. 12.11.2020

Based on my logic only records 3 and 4 would show as they are NOT today.

Many thanks in advance!

[Pragati11 · Accepted solution]

Hi @andrewb95 ,

Just try creating a caluclated column as follows:

isToday = IF(Tablename[DateCol] = Today(), "Yes", "No")

Now move this column under visual level filter section of your table by selecting it's value to "No".

This will just show you the records for the dates which are not for today's date.

Thanks,

Pragati