Power BI: Convert text (yyyymmdd) to date (dd/mm/yyyy)
Solution 1
Solution 1 :
Highlight the specific column , and on the Transform tab you can select Detect Data Type.
Solution 2 :
Try to create a new column named [dateFormatted]
and apply the formula as follows:
dateFormatted = Date(Left([date],4),Right(left([date],6),2),right([date],2)
select the new column and change its type to date as follows:
[dateFormatted]
will now be of type date, formatted as: dd Mmm yyyy
Solution 2
Solved: Highlight column in question, and on the Transform tab, select Detect Data Type. This switches it from String to Whole number. Then alter Data Type to Date. format provided is dd/mm/yyyy. Hope someone else finds this useful
Solution 3
Just set the datatype to date.
M-Code although can be done through the GUI
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}})
in
#"Changed Type"
Solution 4
Using insert column from examples, I converted DDMMYYYY
(convert to text) to DD/MM/YYYY
(convert to date) which ended up being this:
= Table.AddColumn(#"Changed Type", "OrganisationStartDate", each Text.Combine({Text.Start([organisation_start_date], 2), "/", Text.Middle([organisation_start_date], 2, 2), "/", Text.Middle([organisation_start_date], 4)}), type text)
obskure_ie
Updated on July 11, 2022Comments
-
obskure_ie almost 2 years
I'm specifically trying to convert string in Column A :
yyyymmdd
todd/mm/yyyy
date format using Power Query Editor in Power BI. I can already perform this in Excel using the formula below: Any ideasExcel
=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
-
TheRizza over 2 yearsYou don't need to do the Detect Data Type step. Just select the icon on the left side of the column heading and choose Date.