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
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
Hi @chiragpatel_1
One way of doing this.
Many thanks
Shanker V
