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 Powe...
Need Help
  • m_dekorte's avatar
    m_dekorte
    2 years ago

    Hi Anonymous,

     

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

     

    I hope this is helpful

m_dekorte's avatar
m_dekorte
Resident Rockstar
2 years ago

Hi Anonymous,

 

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

 

I hope this is helpful

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Awesome, it worked ! thanks m_dekorte