Custom Calculated Column

[Anonymous]

I want a calculated column that will return a customised column as shown in the snip below, so that when i use the column as a filter on my report, users can select current month to show details for the active month.

Many thanks for the assistance.

[amitchandak · Accepted solution]

@Anonymous , In you date table you can have a column like

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

or

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

Sort this on a column Format([Date],"YYYYMM")

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