Filter a Power Apps gallery to show only dates in the last quarter.
Input
Calendar Dates is a SharePoint list with consecutive days starting 1/1/2018 and ending 12/31/2024 (2,557 rows)
| Title | CalendarDate |
| Monday, January 1, 2018 | 1/1/2018 |
| Tuesday, January 2, 2018 | 1/2/2018 |
| Wednesday, January 3, 2018 | 1/3/2018 |
| Thursday, January 4, 2018 | 1/4/2018 |
| Friday, January 5, 2018 | 1/5/2018 |
| … | … |
| Tuesday, December 31, 2024 | 12/31/2024 |
Code
Use this code in the Items property of a gallery.
With(
{
StartDate: Date(
Year(Today()),
Month(Today())
-If(
Mod(Month(Today())-1,3) = 0,
0,
Mod( Month(Today())-1, 3)
)-3,
1
),
EndDate: Date(
Year(Today()),
Month(Today()) + 3-Mod(Month(Today())-1,3)-3,
1
)-1
},
Filter(
'Calendar Dates',
CalendarDate >= StartDate,
CalendarDate <= EndDate
)
)
Output
Gallery shows only rows with a date in the last month. Current date is 6/16/2021.
| Title | CalendarDate |
| Friday, January 1, 2021 | 1/1/2021 |
| Saturday, January 2, 2021 | 1/2/2021 |
| Sunday, January 3, 2021 | 1/3/2021 |
| Monday, January 4, 2021 | 1/4/2021 |
| Tuesday, January 5, 2021 | 1/5/2021 |
| Wednesday, January 6, 2021 | 1/6/2021 |
| Thursday, January 7, 2021 | 1/7/2021 |
| Friday, January 8, 2021 | 1/8/2021 |
| Saturday, January 9, 2021 | 1/9/2021 |
| Sunday, January 10, 2021 | 1/10/2021 |
| Monday, January 11, 2021 | 1/11/2021 |
| Tuesday, January 12, 2021 | 1/12/2021 |
| Wednesday, January 13, 2021 | 1/13/2021 |
| Thursday, January 14, 2021 | 1/14/2021 |
| Friday, January 15, 2021 | 1/15/2021 |
| Saturday, January 16, 2021 | 1/16/2021 |
| Sunday, January 17, 2021 | 1/17/2021 |
| Monday, January 18, 2021 | 1/18/2021 |
| Tuesday, January 19, 2021 | 1/19/2021 |
| Wednesday, January 20, 2021 | 1/20/2021 |
| Thursday, January 21, 2021 | 1/21/2021 |
| Friday, January 22, 2021 | 1/22/2021 |
| Saturday, January 23, 2021 | 1/23/2021 |
| Sunday, January 24, 2021 | 1/24/2021 |
| Monday, January 25, 2021 | 1/25/2021 |
| Tuesday, January 26, 2021 | 1/26/2021 |
| Wednesday, January 27, 2021 | 1/27/2021 |
| Thursday, January 28, 2021 | 1/28/2021 |
| Friday, January 29, 2021 | 1/29/2021 |
| Saturday, January 30, 2021 | 1/30/2021 |
| Sunday, January 31, 2021 | 1/31/2021 |
| Monday, February 1, 2021 | 2/1/2021 |
| Tuesday, February 2, 2021 | 2/2/2021 |
| Wednesday, February 3, 2021 | 2/3/2021 |
| Thursday, February 4, 2021 | 2/4/2021 |
| Friday, February 5, 2021 | 2/5/2021 |
| Saturday, February 6, 2021 | 2/6/2021 |
| Sunday, February 7, 2021 | 2/7/2021 |
| Monday, February 8, 2021 | 2/8/2021 |
| Tuesday, February 9, 2021 | 2/9/2021 |
| Wednesday, February 10, 2021 | 2/10/2021 |
| Thursday, February 11, 2021 | 2/11/2021 |
| Friday, February 12, 2021 | 2/12/2021 |
| Saturday, February 13, 2021 | 2/13/2021 |
| Sunday, February 14, 2021 | 2/14/2021 |
| Monday, February 15, 2021 | 2/15/2021 |
| Tuesday, February 16, 2021 | 2/16/2021 |
| Wednesday, February 17, 2021 | 2/17/2021 |
| Thursday, February 18, 2021 | 2/18/2021 |
| Friday, February 19, 2021 | 2/19/2021 |
| Saturday, February 20, 2021 | 2/20/2021 |
| Sunday, February 21, 2021 | 2/21/2021 |
| Monday, February 22, 2021 | 2/22/2021 |
| Tuesday, February 23, 2021 | 2/23/2021 |
| Wednesday, February 24, 2021 | 2/24/2021 |
| Thursday, February 25, 2021 | 2/25/2021 |
| Friday, February 26, 2021 | 2/26/2021 |
| Saturday, February 27, 2021 | 2/27/2021 |
| Sunday, February 28, 2021 | 2/28/2021 |
| Monday, March 1, 2021 | 3/1/2021 |
| Tuesday, March 2, 2021 | 3/2/2021 |
| Wednesday, March 3, 2021 | 3/3/2021 |
| Thursday, March 4, 2021 | 3/4/2021 |
| Friday, March 5, 2021 | 3/5/2021 |
| Saturday, March 6, 2021 | 3/6/2021 |
| Sunday, March 7, 2021 | 3/7/2021 |
| Monday, March 8, 2021 | 3/8/2021 |
| Tuesday, March 9, 2021 | 3/9/2021 |
| Wednesday, March 10, 2021 | 3/10/2021 |
| Thursday, March 11, 2021 | 3/11/2021 |
| Friday, March 12, 2021 | 3/12/2021 |
| Saturday, March 13, 2021 | 3/13/2021 |
| Sunday, March 14, 2021 | 3/14/2021 |
| Monday, March 15, 2021 | 3/15/2021 |
| Tuesday, March 16, 2021 | 3/16/2021 |
| Wednesday, March 17, 2021 | 3/17/2021 |
| Thursday, March 18, 2021 | 3/18/2021 |
| Friday, March 19, 2021 | 3/19/2021 |
| Saturday, March 20, 2021 | 3/20/2021 |
| Sunday, March 21, 2021 | 3/21/2021 |
| Monday, March 22, 2021 | 3/22/2021 |
| Tuesday, March 23, 2021 | 3/23/2021 |
| Wednesday, March 24, 2021 | 3/24/2021 |
| Thursday, March 25, 2021 | 3/25/2021 |
| Friday, March 26, 2021 | 3/26/2021 |
| Saturday, March 27, 2021 | 3/27/2021 |
| Sunday, March 28, 2021 | 3/28/2021 |
| Monday, March 29, 2021 | 3/29/2021 |
| Tuesday, March 30, 2021 | 3/30/2021 |
| Wednesday, March 31, 2021 | 3/31/2021 |