Help Create EndOfMonthDate using the Date Column in my Dataset

[tnachis]

Hi All, 

I'm working with the dataset below, which contains a StartDate column. The source file's StartDate column was initially formatted as Jan 2024, Feb 2024. However, when extracted into Power Bi, I modified the date format by highlighting the "StartDate" column and then selecting "Data Type Text" under the Transform ribbon, followed by date, to convert the Startdate format.

I would want to use the StarDate field to add an EndOfMonth column.

Thank You!

[m_dekorte · Accepted solution]

Hi @tnachis,

Insert a custom column and enter this in the formula area:
Date.EndOfMonth([StartDate])

I hope this is helpful

[tnachis]

Awesome, it worked ! thanks @m_dekorte