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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Date Format

Hi guys, 

 

I'm trying to format my date value.

Screenshot 2020-11-03 170843.pngScreenshot 2020-11-03 170853.png

 

I would like to have the date format as:

"YYYY-mm-dd"

 

Can somebody help me out with this novice question?

 

Thanks

1 ACCEPTED SOLUTION
edhans
Super User
Super User

You don't "format" dates in Power Query. To convert that to just a date though, you would wrap the above with DateTime.Date, so :

DateTime.Date(DateTime.LocalNow())

That will strip the time component off.

 

If you are using that date field in a query that gets loaded into Power BI, that is where you can change the format of how the date looks. Select the Date field in the field listing after the data has loaded, then on the Column Tools menu, change the format, which doesn't affect the data, just how it is shown.

edhans_0-1604423333697.png

 

 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

2 REPLIES 2
Pragati11
Super User
Super User

Hi @Anonymous ,

 

You can change the date format outside Query Editor. Apply your query changes.

Under FIELDS pane click on your date column, then on the top ribbon you can find different date formats as shown below:

 

Pragati11_1-1604423459470.png

 

 

Pragati11_0-1604423420649.png

 

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

edhans
Super User
Super User

You don't "format" dates in Power Query. To convert that to just a date though, you would wrap the above with DateTime.Date, so :

DateTime.Date(DateTime.LocalNow())

That will strip the time component off.

 

If you are using that date field in a query that gets loaded into Power BI, that is where you can change the format of how the date looks. Select the Date field in the field listing after the data has loaded, then on the Column Tools menu, change the format, which doesn't affect the data, just how it is shown.

edhans_0-1604423333697.png

 

 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors