Query Last 100 Days for Past 3 Years

[1Kash]

Greetings All,

I'm looking to set up a daily query that will pull the last 100 days from TODAY, for the current-year, prior-year and prior-prior-year periods.

The date ranges would look something like this from today's date December 7th:

PPY	PY	CY
12/7/2021	12/7/2022	12/7/2023
8/29/2021	8/29/2022	8/29/2023

I'm using Power Bi Desktop and have a daily scheduled refresh set-up

The code below is what I use to pull the last 100 days each morning, but not sure how to set up for the prior year periods.

= Table.SelectRows(#"Removed Columns", each Date.IsInPreviousNDays([close_date], 100))

Thanks in advance!

[ThxAlot · Accepted solution]

Construct the periods by yourself (take 5 days for example)

let
    Source = let today=Date.From(DateTime.LocalNow()) in List.Accumulate({0..2}, {}, (s,c) => s & List.Dates(Date.AddYears(today, -c), 5, #duration(-1,0,0,0)))
in
    Source

[1Kash]

This worked great. Thanks a lot, ThxAlot