Forum Discussion
Anonymous
4 years agoNot applicable
Issue with using DATEADD
Hello everyone, I have some issues with the DATEADD function when selecting certain filters on the dashboard for calculating the number of YTD sales for a selected year. Number of Sales YTD...
- 4 years ago
HI Anonymous
Number of Sales YTD Comparison = VAR _SD = 'Selected Year'[Parameter Value] VAR _T = TODAY() VAR _TSD = DATE( _SD, MONTH( _T ), DAY( _T ) ) RETURN CALCULATE( DISTINCTCOUNT( 'Sales'[Sales ID] ), FILTER( ALL( 'Sales' ), 'Sales'[Sales Date] >= DATE( _SD, 1, 1 ) && 'Sales'[Sales Date] <= _TSD ) )It'd would be great to add a date table to your model and use that, for adding a date table please check this link: https://www.vahiddm.com/post/creating-calendar-table-with-3-steps
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
wdx223_Daniel
4 years agoCommunity Champion
Time Intelligence Functions need a real date table with full dates.