Forum Discussion
Previous YTD
Hi I'm trying to chart YTD however, I think I have the formula wrong when I put it in to chart instead of only seeing the data for 2022 I seee the date for every year.
Utilization YTD = CALCULATE(Utilisation[Utilisation], DATESYTD('Work Period'[Date]))
Anonymous , You need YTD based on today
YTD Today =
var _min = eomonth(today(),-1*month(today()))+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))
1 Reply
Anonymous , You need YTD based on today
YTD Today =
var _min = eomonth(today(),-1*month(today()))+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))