Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Fiscal Month Filter

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

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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