Calculating YTD while keeping Month filter
I have bellow table data: I want to add a measure calculating the YTD of Value so I added this measure : Mesure = CALCULATE(SUM('Table'[Value]), DATESYTD('Calendar'[Date])) Then in my report I filtered on the month 202302, I have the correct result puting the month and the measure : But when I add the product it's showing two lignes : How can I modify the measure to have just the filtered month 202302, the product2 and Measure ytd = 3.
DATESYTD issue.. how to solve if i have records with dates greater than fiscal end date?
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 : RGN ACV Budget YTD = CALCULATE([RGN ACV Budget], DATESYTD('Calendar'[Date],"03/31")) Sales Fiscal YTD = CALCULATE([TOTAL-WINS], DATESYTD('Calendar'[Date],"03/31"))
