The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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