Forum Discussion
FY Cross Over - Date Range Issue
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...
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.