Last day of the Month Set analysis

[etrotter]

Hello,

I am trying to write a formula that will show me the last day of the month data, here is what I currently have:

{<Date ={"$(MonthStart(Min(Date))-1)"}>}

Please let me know what I should be doing differently for it to recognize it

Thanks!

[sunny_talwar]

Try this

{<Date = {"$(=MonthStart(Min(Date))-1)"}>}

or this

{<Date = {"$(=Date(MonthStart(Min(Date))-1))"}>}

[etrotter]

Neither of those are working

[sunny_talwar]

What is your date field format?

[etrotter]

M/DD/YYYY ex: 9/20/2017

[sunny_talwar]

How about this

Sum({<Date = {"$(=Date(MonthStart(Min(Date))-1, 'M/D/YYYY'))"}>} Measure)

[etrotter]

Avg({<Date = {"$(=Date(MonthStart(Min(Date))-1, 'M/D/YYYY'))"}>} Goal)

its still not working, im using average, could this effect output?

[sunny_talwar]

It should not... can you share an image of the table where you add this as measure and hover over the expression header to show what the expression looks like? Make sure to now use any expression labels

[etrotter]

the expression is: Avg({<Date = {"$(=Date(MonthStart(Min(Date))-1, 'MM/D/YYYY'))"}>} Goal)

[pradosh_thakur]

hi

do you have month or date or year any date related field as dimension ?