Power Apps Filter Gallery By Dates In Previous ‘N’ Quarters

Filter a gallery to show only dates within the previous ‘N’ number of quarters where N is a number specified by the app maker.



Input

Calendar Dates is a SharePoint list with consecutive days starting 1/1/2018 and ending 12/31/2024 (2,557 rows)

TitleCalendarDate
Monday, January 1, 20181/1/2018
Tuesday, January 2, 20181/2/2018
Wednesday, January 3, 20181/3/2018
Thursday, January 4, 20181/4/2018
Friday, January 5, 20181/5/2018
Tuesday, December 31, 202412/31/2024


Code

Use this code in the Items property of a gallery.

With(
    {
        StartDate: Date(
            Year(Today()),
            Month(Today())-(3*2), //change this number
            Day(Today())
        )+1,
        EndDate: Date(
            Year(Today()),
            Month(Today()), 
            Day(Today())
        )
    },
    Filter(
        'Calendar Dates',
        CalendarDate >= StartDate,
        CalendarDate <= EndDate
    )
)


Output

Gallery shows only rows with a date in the previous 2 quarters. Current date is 6/16/2021

TitleCalendarDates
Thursday, December 17, 202012/17/2020
Friday, December 18, 202012/18/2020
Saturday, December 19, 202012/19/2020
Sunday, December 20, 202012/20/2020
Monday, December 21, 202012/21/2020
Wednesday, June 16, 20216/16/2021

(182 rows)