Date transformations are one of the vital data cleaning processes. Power Query can handle common challenges like the system not recognizing the column as date due to its different format or structure, extracting date components like the year, quarter, month, week, and more with ease. Apart from Power Query, we can leverage native Excel feature Text to Column for date transformations.
The topic of the webinar was to highlight one of such features of the Power Query.
Watch the video:
Date transformations with Power Query
Date transformations using Locale
Join the group BI Simplified to stay updated on future webinars and articles.