Assigning dates to value if within a range

[Anonymous]

Hi gurus,

I need your expertise on the below:

1. I have a table with Fiscal Quarters Start and End dates

Quarter	Start	End
Q4-FY22	1-Apr-21	30-Jun-21
Q1-FY23	1-Jul-22	30-Sep-22
Q2-FY23	1-Oct-22	31-Dec-22

2. and another table with dates

23-May-2021

15-Dec-2022

.

.

.

So I want to create a column beside these dates to return 

Q4-FY22 for 23-May-2021

and

Q2-FY23 for 15-Dec-2022

and etc...

Thanks in advance

[amitchandak · Accepted solution]

@Anonymous ,

a new column in the second table

maxx(filter(FY, FY[Start Date]<= Table2[Date] && FY[End Date]>=  Table2[Date]) , FY[Quarter])