Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table with a mix of date formats in one column. Some are in the excel serial number format, and others are in a date/time/timezone format. please see image below.
I need to convert these into date only format. I know how to use transfom and get the date only from the date/time/timezone ones, but I somehow need to fix the serial number ones first. How can I go about this?
Solved! Go to Solution.
I would fix them in a few steps. You can do this 99% with the user interface and simple and easy to follow formulas.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI would fix them in a few steps. You can do this 99% with the user interface and simple and easy to follow formulas.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou had me all the way till step 6 🙂
I did steps 1 - 5 and it worked great, thank you!
But step 6... This is a power BI report and more data will roll in every day. I plan to try to figure out and fix my source, but in the mean time, do I need to leave the conversion formulas and columns in place so that these automaticly convert each day?
No. Tomorrow when new data comes in, it will rerun all of these steps. It is just deleting those columns before it gets loaded to Power BI. Look at the steps that are being created on the right side of the Power Query window. Think of that as a macro. It isn't like Excel where it is permenantly deleting those columns. It only deletes the columns after steps 1-5 are done again.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUnderstood.
Marking solution, Thanks for the help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.