Fiscal Month Filter

[Anonymous]

Does anyone know how to apply a filter that will automatically filter the data to the current fiscal month? 

[amitchandak]

@Anonymous , As of now you need to have a column in date/table and save that on This Month

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

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA