Last week

[chiragpatel_1]

Hi,

What would be a simple way to get last week's data (Mon - sunday) regardless of the current day.

Been struggling with this. Found other solutions confusing.

Many Thanks

[Christina_H · Accepted solution]

I'm assuming you have a date field in your data?  Use something like this in a filter:

ToNumber(DateTimeFormat([Date],"%W"))=ToNumber(DateTimeFormat(DateTimeToday(),"%W"))-1

[ShankerV]

Hi @chiragpatel_1 

One way of doing this.

Many thanks

Shanker V