How can I switch this custom column from TODAY to THIS PAST WEEK

[Anonymous]

I'm making this column for a custom filter that filters for the past 7 days versus today,

Any idea how to do something like this?

Thanks!

[johncolley · Accepted solution]

Hi @Anonymous , You may not require a new column for this. Have you tried including your date in a slicer and changing the filter type to Relative Date?

If this answer solves your problem please mark it as a solution!