Forum Discussion

asebes's avatar
asebes
Frequent Visitor
5 years ago
Solved

Change MMM-YY Format to a Date Format

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) ...
Need Help
  • DataZoe's avatar
    DataZoe
    5 years ago

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

     

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

     

ac-pbi's avatar
ac-pbi
Frequent Visitor
3 years ago

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])