Convert date format from YYYYYMMDD to DD.MM.YYYY

[Anonymous]

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

[amitchandak · Accepted solution]

@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

[Anonymous]

Many Thanks for the quick support