Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |