MAX day of month TRUE or FALSE

[bullius]

Hello,

I would like to add a column to a table. The table includes a date column. I would like the new column to show TRUE if the date is the MAX in any given month. E.g.

Date	New Column
03/04/2016	FALSE
19/04/2016	TRUE
12/04/2016	FALSE
06/05/2015	FALSE
11/05/2016	FALSE
15/05/2016	TRUE

Any suggestions as to what formula might produce this?

Thanks!

[KHorseman]

EndOfMonth = IF(TableName[date] = EOMONTH(TableName[date], 0), TRUE, FALSE)

EOMONTH function

[bullius]

Thanks @KHorseman,

It's not the EOM that I want, it is the MAX date in month; this might be, for example, 22 September, as data is not included for every date in the month.

[KHorseman · Accepted solution]

Oh, just the latest date whether it's the true end of the month or not?

MaxOfMonth = IF(
	Table1[date] = CALCULATE(
		MAX(TableName[date]),
		FILTER(
			ALL(TableName),
			MONTH(TableName[date]) = MONTH(EARLIER(TableName[date])) &&
			YEAR(TableName[date]) = YEAR(EARLIER(TableName[date]))
		)
	),
	TRUE,
	FALSE
)

[bullius]

Thanks @KHorseman,

That's the one!