Forum Discussion
Fragan
Helper III
Helper IIIPower Query Text Field with date to Date type field MM/YYYY
Hey, I have a text field named "date" which obviously have dates in text format (01/2020 for ex), i want to parse those date to format MM/YYYY but i can't really figure this out using Power query...
In DAX you can have a new column like
Date1 = Date(right([date],4),left([date],2),1)
amitchandak
Super User
Super UserIn DAX you can have a new column like
Date1 = Date(right([date],4),left([date],2),1)