Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 f...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

Many Thanks for the quick support