Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Dear All,
My issue is with DATESYTD. My report perfectly works if i have records with dates within the fiscal year. The moment i add records with dates greater than fiscal year end date, all my charts go off . DATESYTD stops functioning. Our FY starts on 01-Apr-2019 and ends on 31-Mar-2020. I have records with dates in April 2020. If i remove the records of April 2020 my report works perfectly fine, the momet i add everything goes off. Please help with solution . Or any alternate functions that i shuld use. Screenshots of the table below. The first image where it works fine as i have records with date less than or equal to 31-Mar-2020. The second image is where it goes off when i adda records with dates greater than 31-Mar-2020. I can't eliminate those records as we always provide next 90days Forecast as well.
Formula is use is as below :
It may be that you need to use DATESBETWEEN(), where you calculate the start and end dates you want. Then the functions will work in the same way no matter what additional dates are present in your data. This might mean adding a parameter table to hold the start and end dates for your fiscal year.
I'm a personal Power Bi Trainer I learn something every time I answer a question
The Golden Rules for Power BI
Help when you know. Ask when you don't!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |