Forum Discussion

NipawanV's avatar
NipawanV
Icon for Helper I rankHelper I
2 years ago

YTD doesn't return the right value

I created YTD formula but it doesn't return the expected value YTD value. Do you have any clue? Customer Price YTD = CALCULATE(     [Customer Price],     DATESYTD(DimDate[Date]) )   ...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
2 years ago

hi NipawanV ,

 

Everything seems OK. what are you expected price YTD on different months? 

NipawanV's avatar
NipawanV
Icon for Helper I rankHelper I
2 years ago

Hello, 

Thanks for the quick response. 

I just want to cross-check if the result given in the first table is correct calculation of YTD .  As to my understanding the YTD suppose to be like in this figure below and the example from previous table on my second picture that show YTD of the Est. Reveue YTD as it's suppose to be which is quite correct in my opinion. 


So if it's correct.  I want to know how does PBI calculate Customer Price YTD on the above table to get such figures.