FY Cross Over - Date Range Issue

[Maya-RO]

Hello.

My data should include a row for FY23 (accounting for the last row, a date range that crosses over into FY23). There should be another row from 10/01/22 through 01/04/23 with a total of 95 days. However, the expected extraction of FY23 days is not occurring. In other words, my formula is not extracting the correct number of days by FY. The start and end dates cross over
the beginning of a FY which may be causing the issue. As you can see, the FY23 dates are not being counted (the FY 22 and FY23  filters are selected).  The last "date range of an event" started on Sept 29th and ended on 01/04/23; the formula should be  separating out both FY's this date range crosses over. In the month of September, it is counting days that belong to FY23 (97).

Only the FY 22 dates of the last row are being counted. There should be an additional row isolating or counting the number of days
starting on Oct 1st through today to separate FY 22 and FY23 dates.  

[v-jianboli-msft]

Hi @Maya-RO ,

What does your raw data look like and what is the slicer used for? What kind of result do you want, are the two columns calculating the date of FY22 and FY23 separately? What if other FY is selected?

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.