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-Se...
Anonymous ,
a new column in the second table
maxx(filter(FY, FY[Start Date]<= Table2[Date] && FY[End Date]>= Table2[Date]) , FY[Quarter])
Anonymous ,
a new column in the second table
maxx(filter(FY, FY[Start Date]<= Table2[Date] && FY[End Date]>= Table2[Date]) , FY[Quarter])