cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eduardormaia
Frequent Visitor

M Language - Transforming Data format

Dear Masters of M Language,

 

Need help to work with data formats in M Language.

 

I have a column with the format dd/mm/yyyy  hh:mm:ss I need to replicate this column containing only dd/mm/yyyy.

 

I'm sure it's very simple, please help.

1 ACCEPTED SOLUTION
EtienneOL
Resolver III
Resolver III

Hi @eduardormaia ,

PowerBI does not directly identify a date from a format dd/mm/yyyy hh:mm:ss but if you first convert your text to date/time it will work.

 

How to do this : 

1. On top of your culumn you can chose data type for your column. Click there and choose Date/Time.

image.png

image.png

Repeath this step but chose "Date" this time.

Dont replace current change but add a new step (screenshot below)

image.png

Tell me if this worked as desired ! 

Regards, 

Etienne

View solution in original post

2 REPLIES 2
EtienneOL
Resolver III
Resolver III

Hi @eduardormaia ,

PowerBI does not directly identify a date from a format dd/mm/yyyy hh:mm:ss but if you first convert your text to date/time it will work.

 

How to do this : 

1. On top of your culumn you can chose data type for your column. Click there and choose Date/Time.

image.png

image.png

Repeath this step but chose "Date" this time.

Dont replace current change but add a new step (screenshot below)

image.png

Tell me if this worked as desired ! 

Regards, 

Etienne

View solution in original post

Thanks! It worked just fine.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors