Date table for last day of each month

[ClemFandango]

Hello all,

I think this is quite an easy one, but I am still struggling with it.

I would like the MMYYDD column to represent the last day of each month - it is currently showing the 1st.

This is my code so far:-

Dates2 =

 GENERATE ( CALENDAR(

 DATE ( YEAR ( MIN ( 'date'[Start Date] ) ), 1, 1 ),

 DATE ( YEAR ( MAX ( 'date'[End Date] ) ), 12, 1 )),

 VAR currentDay = [Date]

 VAR month = MONTH ( currentDay )

 VAR year = YEAR ( currentDay )

 RETURN ROW (

 "MMYYDD", DATE(year,month,01)

 ))

Any thoughts gleefully welcomed!

Date	MMYYDD
01/01/2018 00:00	01/01/2018 00:00
02/01/2018 00:00	01/01/2018 00:00
03/01/2018 00:00	01/01/2018 00:00
04/01/2018 00:00	01/01/2018 00:00
05/01/2018 00:00	01/01/2018 00:00
06/01/2018 00:00	01/01/2018 00:00
07/01/2018 00:00	01/01/2018 00:00
08/01/2018 00:00	01/01/2018 00:00
09/01/2018 00:00	01/01/2018 00:00
10/01/2018 00:00	01/01/2018 00:00

[ClemFandango]

Thank you @FreemanZ  & @ERD  both excellent solutions!

[FreemanZ]

hi @ClemFandango 

to add a column for end of month of a date column, try like:
column = EOMONTH([date],0)

[ERD · Accepted solution]

Hi @ClemFandango ,

You can use 

ROW ( "MMYYDD", EOMONTH( [Date], 0 ) )