Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Date from TEXT

‎02-10-2022 10:07 PM

I have a date column on CSV file where dates are written in this format 13012022

I want to convert to date so that i can select date type and can add slicer on Power BI. Please help.

Labels:
Message 1 of 4
690 Views
1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

‎02-10-2022 11:17 PM

@Anonymous Try this DAX Column:

Date Column =
VAR Month_ = MID('Table'[Date],3,2)
VAR Day_ = LEFT('Table'[Date],2)
VAR Year_ = RIGHT('Table'[Date],4)
RETURN DATE(Year_,Month_,Day_)
 
Capture.JPG
 
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

Message 4 of 4
610 Views
3 REPLIES 3
Tahreem24
Super User
Super User

‎02-10-2022 11:17 PM

@Anonymous Try this DAX Column:

Date Column =
VAR Month_ = MID('Table'[Date],3,2)
VAR Day_ = LEFT('Table'[Date],2)
VAR Year_ = RIGHT('Table'[Date],4)
RETURN DATE(Year_,Month_,Day_)
 
Capture.JPG
 
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Message 4 of 4
611 Views
ALLUREAN
Solution Sage
Solution Sage

‎02-10-2022 10:53 PM

Hi, @Anonymous 

This sample is using Power Query to do the transformations.

https://www.dropbox.com/s/4b6n3ofqpujnfc4/text%20to%20date%20%28allure-analytics.com%29.pbix?dl=0

 

Added also using DAX calculated column

NewDateDAX = LEFT('Table'[Text],2) &"-"& MID('Table'[Text],3,2)&"-"& RIGHT('Table'[Text],4)
 

 




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!
Message 3 of 4
634 Views
0
Anonymous
Not applicable

‎02-10-2022 10:42 PM

maybe you can try it by Calculated column：

DateNew = MID（[date]，5，4）&"-"&MID（[date]，3，2）&"-"&MID（[date]，1，2)

jak11_0-1644561721414.png

 

Message 2 of 4
649 Views

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All