Forum Discussion

Manikantans2's avatar
Manikantans2
Frequent Visitor
4 years ago
Solved

Default Month Filter along with MoM

Greetings,    I have a 'Period' column and a 'Revenue' column in my table. I have set up a calendar table as well.  I am displaying previous month revenue (Previous of the month selected in the mo...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Manikantans2 , Create a column like this and try

     

    Month Type = Switch( True(),
    eomonth([Date],0) = eomonth(Today(),-1),"Last Month" , //Last Month
    eomonth([Date],0)= eomonth(Today(),0),"This Month" , //This Month
    [Month Year]
    )

Manikantans2's avatar
Manikantans2
Frequent Visitor
4 years ago

Hi Amit, 

 

The solution you provided is working. I guess i had to "Mark as Date Table" for the calendar table in addition. Thanks for the solution.