Forum Discussion
Nischal
Helper I
8 years agoDAX TOTALYTD() - Duplicate Date Error
not able to visualize the YTD sales ... so what is wrong in the dax Total Sales YTD = TOTALYTD(sales_attributes1[Total Sales],sales_attributes1[DATECREATED] ) the calculation error in sales[t...
JPT145
Microsoft Employee
4 years ago4 years late but ... So I have found out If you already have a Column that has the dates lets call it {Date item was sold} or in your case if it lists the dates in a format such as {Friday, January 28,2022} then it the [TotalYTD] funtion won't work as a approrate value for the <Date> portion of the measurment.....and gives you the error you have seen.
The Date format I have seen the [TotalYTD] measure function like is MM/DD/YYYY once I Transformed my data in the {Date item was sold} from the date format of {Friday, January 28,2022} to {1/28/2022} then it worked like a charm!