Change MMM-YY Format to a Date Format

[asebes]

Seems like this should be easy but can't quite get it.  Have text in the following format that needs to be converted to a date format (last day of the month).  Thank you!

Current Format (MMM-YY)                     Desired Output

Dec-19                                                     12/31/19

Jan-20                                                      1/31/20

Feb-20                                                      2/28/20

[ac-pbi]

I wanted to do this in Power Query instead of DAX and creating a Custom Column with this formula worked for me (credit to ChatGPT for the assist):

=Date.FromText("01-"&[YourTextColumnHere])

[DataZoe · Accepted solution]

@asebes and to add to @mahoneypat 's reponse, here is a DAX calculated column version:

EOM Date = EOMONTH("1-"&'Table'[Date Text],0)

[mahoneypat]

You can add a custom column in the query editor with this formula to get your desired result.

= Date.EndOfMonth(Date.From([Current Format]))

Pat