Cumulative Total Mistake Month-wise

[Vallirajap]

Hii All,

I want to find the YTD for the fiscal year. So I use two types of functions: DatesYTD and TotalYTD.

DatesYTD = CALCULATE([Dummy], DATESYTD('Date'[Date], "3/31"))   
         //Dummy as a measure contains a lot of variables in addition to giving the output.
Total YTD = TOTALYTD([Dummy], 'Date'[Date], "3/31")

The two display the same thing, but it is wrong.

In my scenario,
Apr/23 = 683 
May/23 = 698    => 683 + 698 = 1381, but the YTD displays 1034.

Nearly 347 is missing in the YTD formula, but the next month is calculated correctly. 347 is missing for the whole YTD.

Is there any problem implementing YTD, and is there any other formula to find the YTD?

Also, I am using the below one, but I don't know how to break the YTD for the fiscal year. is calculating the YTD for the whole year in the dataset.

Dummy 2 =CALCULATE([Dummy], FILTER( ALL('Date'), 'Date'[Date] <= MAX('Date'[Date])))

Anyone who knows, please tell
Thanks in advance! 

[v-yohua-msft]

Hi, @Vallirajap 

The missing 347 in the calculation may be due to missing data for some month in the dataset or incorrect aggregation in the measure. Review the underlying data for any gaps or errors that could cause the totals to be incorrect.

If you can, please provide more details with your desired output and pbix file without privacy information (or some sample data)

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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