Power BI : Converting YYYYMMDD to Proper Date in Power Query Editor
I’m sure as a data analyst or as someone who performs ETL in power query you may have once being hit with the challenge of some data with date field in this format ‘YYYYMMDD’ (i.e. 20220131) and you wonder, how do I transform this to a proper date (i.e. 01–31–2022) format in power query? No worries bruh I’ve got you! This can be achieved simply with a quick trick without having to any write complex formulas at all! Let’s get right into how to do this step by step!
1. First things first, you will have to import your data into power query by clicking on the Get Data button. Select the table you would want to perform the transformation on then you hit the Transform Data button.
2. With the data loaded into power query editor you select the offending column which is the date and then click the transform tab. You then click on the dropdown of the menu data type and then convert the format to a text and select add new step on the change column type pop-up.
3. You then click on the data type dropdown menu again, this time around you select the date option, add new step again. Boom 💥, your date column is now transformed to a proper date format.
You realise its that simple.
