Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
  • VahidDM's avatar
    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/