Forum Discussion
Drop down Filter for every past month
Hi I have a question how to create a filter like this and this filter should be dynamic and add new past month every time there is a new past month Thank
Anonymous , Create a flag like this in date table and use that in visual level filter
Month Type = Switch( True(),
eomonth([Date],0) <= eomonth(Today(),-1) ,1, 0
)
amitchandak
Super User
Super UserAnonymous , Create a flag like this in date table and use that in visual level filter
Month Type = Switch( True(),
eomonth([Date],0) <= eomonth(Today(),-1) ,1, 0
)