Forum Discussion
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) ...
asebes and to add to mahoneypat 's reponse, here is a DAX calculated column version:
EOM Date = EOMONTH("1-"&'Table'[Date Text],0)
DataZoe
Microsoft Employee
Microsoft Employeeasebes and to add to mahoneypat 's reponse, here is a DAX calculated column version:
EOM Date = EOMONTH("1-"&'Table'[Date Text],0)