Date Silcer issues with Table Data

Hi All,
I have a Date Slicer and Table which contains Calender Date.
I have mapped One to Many Relationship and Single in between both.
In may Table visual, i have created a FY Year Column with below condition.

FYYear1 =

 IF ( Table1[CalenderDate] >= Date(2021,07,01) && Table1[CalenderDate] <= Date(2022,06,30),"FY22",

IF ( Table1[CalenderDate] >=Date(2022,07,01) && Table1[CalenderDate] <= Date(2023,06,30),"FY23",

IF ( Table1[CalenderDate] >= Date(2023,07,01)  && Table1[CalenderDate] <= Date(2024,06,30),"FY24","")))

 

Interestingly i found few issues.
1. When i select time period in my Silcer for 2022/07/01 to 2022/11/30 -> its shows only FY23 data in the table (It is expected and working as expected)

2.  When i select time period in my Silcer for 2021/07/01 to 2022/06/30 -> its shows only FY22 and FY23 data in the table (It is not  expected)
2.  When i select time period in my Silcer for 2021/07/02 to 2022/06/30 -> its shows only FY22 data in the table (It is expected but it is not desired result)

 

Additionally, I have manipulated Date ranges in the FYYear1 column instead of >=(dates) or <=(dates) to >(dates) and < (dates) and still it does not worked as expected.

 

 

 

 

 

Regards

Santosh Kumar