Forum Discussion
Last 4 years + YTD
Hi, I am trying to add a filter to my visuals in a report. I want to see the last 4 years + YTD. If I choose last 5 calendar years I don't get current year. If I choose last 5 years I don't...
amitchandak
Super User
Super UserMenvf ,Try a measure like
YTD Today +4 =
var _min = date(year(today()) -4,1,1)
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max)) // assuming you are using date table or use date from table
amitchandak thank you for your effort, however it still doesn't work even when I change the date reference.
What is the [Net] reference in the calculate?