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.
Anyone knows how can i achieve this ?
In DAX you can have a new column like
Date1 = Date(right([date],4),left([date],2),1)
1 Reply
- amitchandak
Super User
In DAX you can have a new column like
Date1 = Date(right([date],4),left([date],2),1)