Custom Period - YTD Figure

[misiek5510]

Hi all,

The Below works, however the YTD figure looks at the min date in the whole date column and I have to filer the visual to 2022 year, so I'm wondering if I can amend the dax, so it looks for min date in current year. 

DATESBETWEEN('Shared Dates'[Date],min('Shared Dates'[Date]),today() )

Currently using this:

View By Last X Days = 
VAR    
    _7days = ADDCOLUMNS(
         CALCULATETABLE(
            'Shared Dates'
            ,DATESBETWEEN('Shared Dates'[Date],today()-7,today() )
        )
        ,"In the last", "7 Days"
    )

     VAR    
    _ytd = ADDCOLUMNS(
         CALCULATETABLE(
            'Shared Dates'
            ,DATESBETWEEN('Shared Dates'[Date],min('Shared Dates'[Date]),today() )
        )
        ,"In the last", "YTD"
    )

return 
UNION(_7days,_ytd)

[johnt75 · Accepted solution]

You could use

View By Last X Days = 
VAR    
    _7days = ADDCOLUMNS(
         CALCULATETABLE(
            'Shared Dates'
            ,DATESBETWEEN('Shared Dates'[Date],today()-7,today() )
        )
        ,"In the last", "7 Days"
    )

     VAR    
    _ytd = ADDCOLUMNS(
         CALCULATETABLE(
            'Shared Dates'
            ,DATESBETWEEN('Shared Dates'[Date], DATE( YEAR(TODAY()), 1, 1),today() )
        )
        ,"In the last", "YTD"
    )

return 
UNION(_7days,_ytd)

[misiek5510]

This worked perfectly. Thanks 🙂