Forum Discussion

misiek5510's avatar
misiek5510
Helper III
3 years ago
Solved

Custom Period - YTD Figure

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)

 

  • 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)

2 Replies

  • 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)