Need Solution without slicer values show current year

Anonymous — Mon, 03 Oct 2022 22:36:00 GMT

need this eroor soliution

Re: Need Solution without slicer values show current year

amitchandak — Tue, 04 Oct 2022 02:31:27 GMT

Anonymous , In case of some other year is selected, use all('Date') in place of 'Date' in filter

YTD Today =
var _min = eomonth(today(),-1*month(today()))+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

LYTD Yesterday =
var _today = TODAY()-1
var _max = date(year(_today)-1, month(_today), day(_today))
var _min = eomonth(_max,-1*month(_max))+1
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

This year Today =
var _min = eomonth(today(),-1*month(today()))+1
var _max = eomonth(_min,11)
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Last year Today =
var _max = eomonth(today(),-1*month(today()))
var _min = eomonth(_max,-12)+1
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304

topic Need Solution without slicer values show current year in DAX Commands and Tips

Need Solution without slicer values show current year

Re: Need Solution without slicer values show current year