Forum Discussion
Assigning dates to value if within a range
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
Anonymous ,
a new column in the second table
maxx(filter(FY, FY[Start Date]<= Table2[Date] && FY[End Date]>= Table2[Date]) , FY[Quarter])
1 Reply
Anonymous ,
a new column in the second table
maxx(filter(FY, FY[Start Date]<= Table2[Date] && FY[End Date]>= Table2[Date]) , FY[Quarter])