Showing results for 
Search instead for 
Did you mean: 

Enhance on the Date Filters



I am preparing a dashboard whereby I can view my records based on week. It seems like there is no formula that allows me to match by Week. Similar to Excel we can filter by This Week, Next Week.. etc.


So will be good to have these formula added.


Thank You

Boon Yar

Status: Planned
Power Apps

You could use the DateDiff function to see how many days away from Now your date is, and if less than 7 then it is this week, if 7-14 then next week, etc.

Advocate I
Hi Andy,

Yup thanks. I did that way already. Just thought it will be good to have these predefined filters or formulas for ease of use.

Boon yar
Power Automate
Status changed to: Planned
Advocate I

Thanks! Thats great!