Forum Discussion

fireflyxxoo's avatar
fireflyxxoo
Frequent Visitor
3 years ago

Measure : Date filter default end month

Hello all,

 

I have a date filter  -  I created a date table and it has a relationship to my main table. 

 

I need by default to make the date filter dynamic is that by default the date filter will always select the end of this month. 

 

it has to be a measure.

 

Any thoughts?

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    fireflyxxoo , You can not default on a measure as of now

     

    Create a column like

    if([Date] = eomonth([date], 0) , "Current Month", format([date], "MMM-YYYY")

     

    You can save on current month