Is there a PQL equivalent to the MDX Generate function?
I have a report that I am trying to build that will display a current year period and a prior year period. The user needs to be able to select a date range. The report would put the selected dates into the Current Year column and the same dates for the previous year into the Prior Year column. In MDX, I would generate the Prior Year dates like this:
GENERATE({ @DateRange }, { ParallelPeriod([Book Date].[Hierarchy].[Year], 1, [Book Date].[Hierarchy].CurrentMember) })
This would loop through all the dates in the parameter and go back to the same periods in the previous year. I'm not sure how to do something similar in PQL.
For example, I want to show a report that compares the data for dates 1/1/26 through 5/31/26 to data for 1/1/25 through 5/31/25.

How would I do this in PQL?