Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi guys,
I'm trying to format my date value.
I would like to have the date format as:
"YYYY-mm-dd"
Can somebody help me out with this novice question?
Thanks
Solved! Go to Solution.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @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:
Thanks,
Pragati
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting