cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eduardormaia Frequent Visitor
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

Accepted Solutions
EtienneOL Member
Member

Re: M Language - Transforming Data format

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 Member
Member

Re: M Language - Transforming Data format

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

Highlighted
eduardormaia Frequent Visitor
Frequent Visitor

Re: M Language - Transforming Data format

Thanks! It worked just fine.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 268 members 2,867 guests
Please welcome our newest community members: