Skip to main content
cancel
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
mattthew
Frequent Visitor

Date does not convert correctly (Text)

Date

Jan-15

Feb-15

Mar-15

Apr-15

May-15

Jun-15

 

Newbie here.....

Date column listed as text when converting to Date I get 01/15/19, 02/15/19, etc....

How can this convert without adjusting the years to days??  Thanks.

1 ACCEPTED SOLUTION
mattthew
Frequent Visitor

Month/Date = FORMAT(Table1[Attribute], "MM/YYYY")
 
did the trick..

View solution in original post

1 REPLY 1
mattthew
Frequent Visitor

Month/Date = FORMAT(Table1[Attribute], "MM/YYYY")
 
did the trick..

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.

Top Solution Authors