Date Silcer issues with Table Data

[SantoshKumar]

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 

[v-easonf-msft · Accepted solution]

Hi, @SantoshKumar 

No obvious errors were found in the formula. Have you checked your raw data?

Please checked the result returned for FYYear1 on 2021/07/01.

Best Regards,
Community Support Team _ Eason

[SantoshKumar]

I worked out on the data and when i created a column in the Calender Table ( which is DateCalenderTable), it worked as expected. thanks for checking and providing feedback.

Appreciate your efforts.