How to create two different date filters/ formulas to cater two different years information

[former_member787075]

Hi guys,

I have the following variables for the prompt.

RP1 From - 17th of March,2022

RP1 To -21st of March,2022.

RP2 From - 18th of March,2021

RP2 To - 22nd of March,2021

I need a date column for each year and a relevant sales measures needs to be added. I can easily bring in all the dates in 2022 and a following sales values on the side. I did this by putting in "Calendar Date" and filter to only show dates for 2022

But the problem is how can I add another column for 2021 date and their following measures?

2022 Date 2022 Sales 2021 Date 2021 Sales

17th $2 18th $6

18th $5 19th $8

19th $5 20th $8

20nd $5 21st $10

[former_member776207]

Hello,

Can you share your current array structure and the one you want to achieve?

Thank you in advance

[former_member776207]

If I understood correctly, you are trying to reproduce a table as follows :