topic Re: Dynamic values based on selected year in DAX Commands and Tips

Dynamic values based on selected year

Anonymous — Mon, 15 Nov 2021 18:40:57 GMT

I've dimensional data which includes "published year". I would like to add a conditional column that changes based on the year(s) the date range of the sales data meaning if I fx. select sales data for 2020, the DIM_releasedate should show "Frontlist" for all projects released in 2020 and "Backlist" for titles published before 2020. It needs to look at the must current year if sales date for multiple years are selected.

Re: Dynamic values based on selected year

amitchandak — Tue, 16 Nov 2021 03:33:44 GMT

Anonymous , A column can not use slicer value , You can create measure

example

var _max = year(maxx(allselected('Date'),'Date'[Date]) )

return

Switch( true() ,

year(Max(Table[projects released])) < _max , "Frontlist" ,

year(Max(Table[projects released])) = _max , "Backlist" ,

"Other"

)