Last month filter

[Anonymous]

Hi, i need to do a slicer filter which will be the last month of the current moment and change automatically. 

[Anonymous]

You want your questions answered? Please follow these guidelines. Thanks.

[amitchandak]

@Anonymous , You can create a column like this in you date table/ table and use that

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

Try : https://www.youtube.com/watch?v=hfn05preQYA