Date table with last date, being the last date of current month

[Thim]

Hi all.

I usually make a Date table showing all dates up to the date we are in.

The Dax formula looks like this.

Date = CALENDAR(DATE(2015;10;1); DATE(YEAR(NOW());MONTH(NOW());DAY((NOW()))))

So as of today, the last date in the table is 19th of October 2018.

However, i need to change this so the table always expand to the last date of the current month, so the last date would be 31th of October 2018.

And ofcourse, when we reach November, the table needs to update so the last date is 30th of November 2018.

Hope someone has the solution i can't find. 🙂

Thank you in advance. 🙂

[PattemManohar · Accepted solution]

@Thim Please try this, using "New Table" option.

Test11DateGen = CALENDAR("2018-01-01",EOMONTH(TODAY(),0))

[Thim]

Thank you.

This looks to be exactly what i was looking for. 🙂