topic Re: Last month filter in DAX Commands and Tips

Last month filter

Anonymous — Fri, 23 Apr 2021 15:23:10 GMT

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

Re: Last month filter

amitchandak — Mon, 26 Apr 2021 04:42:13 GMT

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

Re: Last month filter

Anonymous — Mon, 26 Apr 2021 04:47:56 GMT

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