Measure : Date filter default end month

[fireflyxxoo]

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?

[amitchandak]

@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