Forum Discussion
Dynamic Date calculated column
Setup: Two Tables - Data Table and Date Table Data Table Date ValueID Total 2021/02/03 1 20 2021/02/02 1 15 2021/01/31 1 12 ....... 2...
Anonymous , Create a column like this in date table and use that as filter
Switch( true() ,
eomonth('Date'[Date],0) = eomonth(max(Data[Date]),0) && 'Date'[Date] < Today() , "Current",
"Other"
)