Forum Discussion
Format
Alright, you should be able to follow the following steps:
Starting table with two dates:
Add this custom column to make all dates 8 digit:Column = if Text.Length([Date]) = 8 then [Date] else "0" & [Date]
Giving the following result:
Finally we add the last column to convert it to the correct format:Column 2 = Text.Start([Column] , 2) & "." & Text.Range([Column] , 2 , 2) & "." & Text.End([Column] , 4)
Giving the following result:
Which you can simply convert to date:
Br,
J
Do you want the date to remain a string/text value or do you also want it converted to datetype?
In Power Query you can use the following column:
Column =
Text.Start([Column] , 2) & "." &
Text.Range([Column] , 2 , 2) & "." &
Text.End([Column] , 4)
In Dax you can use the following:
Column = LEFT('Table'[Column] , 2) & "." & RIGHT(LEFT('Table'[Column] , 4) , 2) & "." & RIGHT('Table'[Column] , 4)
Let me know how it goes.
/ J
I want tp convert it to a date datatype.
Alright, you should be able to follow the following steps:
Starting table with two dates:
Add this custom column to make all dates 8 digit:Column = if Text.Length([Date]) = 8 then [Date] else "0" & [Date]
Giving the following result:
Finally we add the last column to convert it to the correct format:Column 2 = Text.Start([Column] , 2) & "." & Text.Range([Column] , 2 , 2) & "." & Text.End([Column] , 4)
Giving the following result:
Which you can simply convert to date:
Br,
J