After applying these functions, try setting the column’s data type again. 4] Manually set delimiters and locale. If your data involves regional settings, ensure that Power Query uses the correct ...

Power Query is quick and requires no specialized knowledge of Excel functions. How to get the data into Power Query We’ll work with a simple Excel sheet with a few delimited strings in a Table ...

Once the data, including the date of birth, is in Power Query, you can add an age column as follows: Select the date of birth column. In this case, that’s DOB.