Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Help Create EndOfMonthDate using the Date Column in my Dataset

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!

  • Hi Anonymous,

     

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

     

    I hope this is helpful

2 Replies

  • m_dekorte's avatar
    m_dekorte
    Resident Rockstar

    Hi Anonymous,

     

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

     

    I hope this is helpful