Forum Discussion

Nischal's avatar
Nischal
Icon for Helper I rankHelper I
8 years ago

DAX 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...
Need Help
Floriankx's avatar
Floriankx
Icon for Solution Sage rankSolution Sage
8 years ago

Hello you have to create a separate DateTable with contigous unique dates and relate the date columns.

There are dozens of posts how to do so. Here or here.

 

Total Sales YTD = TOTALYTD(sales_attributes1[Total Sales],DateTabel[Dates] )

Nischal's avatar
Nischal
Icon for Helper I rankHelper I
8 years ago

hi, both i tried doing the same by using calendar function the issue is i am getting a blank totalytd