Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

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:

fizzi_0-1640854138184.png

 

Many thanks for your support

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
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

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
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

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Many Thanks for the quick support

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors