How to set date range for comparing this year and last year (to date)

Get Help
2

Hi @taufik
With a bit more complex expression, then you should be able to do it, example:

# This year
SumIf([sales], between([date], relativeDateTime(0, "year"), relativeDateTime(0, "day")))
# Previous year
SumIf([sales], between([date], relativeDateTime(-1, "year"), relativeDateTime(-365, "day")))