Forum Discussion
Convert date format from YYYYYMMDD to DD.MM.YYYY
Hi all,
I tried a lot of other soloution from other links: https://community.powerbi.com/t5/Desktop/How-to-change-YYYYMMDD-into-date-format/m-p/2259500#M821489
But I have no success, wihich formular I have there to insert to get success:
Many thanks for your support
Anonymous , hope this is in text format
in power query
Text.End([Date],2) & "." & Text.Middle([Date],4,2) & "." & Text.Start([Date],4)
Middle is using 4 , because power query index start from 0
refer
Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0
In dax, right, mid, left
Text Operations- Mid, Left, Right: https://www.youtube.com/watch?v=-KChpAz_fUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=47
2 Replies
- amitchandak
Super User
Anonymous , hope this is in text format
in power query
Text.End([Date],2) & "." & Text.Middle([Date],4,2) & "." & Text.Start([Date],4)
Middle is using 4 , because power query index start from 0
refer
Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0
In dax, right, mid, left
Text Operations- Mid, Left, Right: https://www.youtube.com/watch?v=-KChpAz_fUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=47