Forum Discussion
misiek5510
3 years agoHelper III
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
- johnt75Super User
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)- misiek5510Helper III
This worked perfectly. Thanks 🙂