dynamic date selecting a date filter

var Year = Selectedvalue( table[year] ) + 1
var startofYear = DATE( Year, 1, 1 )
var startofFollowingYear = DATE( Year + 1, 1, 1 )
var endofYear = startofFollowingYear - 1
return
"-starts before " & startofYear & " and end after " & startofFollowingYear & "." & CHAR(10) &
"-starts before " & startofYear & " and end on " & endofYear & "." & CHAR(10) &
"starts and end in " & Year & "." & CHAR(10) &
"starts in " & Year & "and ends after " & startofFollowingYear & "."

You might want to wrap the dates in FORMAT( , "dd/mm/yyyy") to format them as you like