Forum Discussion
Time intelligence issues with SAMEPERIODLASTYEAR and DATEADD functions
I create three calculated Tables from my Date Dimension Table 'Order Date' and I see different days than expected. Table 1 = DATESYTD('Order Date'[Date]) Table 2 = DATEADD(DATESYTD('Order Date'[Dat...
I am still confused. What I read is "Returns a set of dates in the year up to current date" current date means that it knows what the curent day is.
If not then could you please give me a few examples of what DATESYTD would return given a specific inputs? Thank you for your time.
Current Date always means the current date as visible in the current filter context. As I said, if that was always the current real date, the function would be of no use.
If you select Sep-1999 in your date table, then DATESYTD( Dates[Date] ) will return dates from 1999-01-01 up to and including the last day of September 1999.
Best
Darek