What Is The Power Query Code To Transform A Date

The text discusses various methods for transforming and converting date values in Power Query. These include using the Transform and Change Type options in the software, as well as using the Power Query M language to extract and format dates. The focus is on converting dates into YYYY-MM format and creating a single field with YYYYMMDD values. Overall, the text emphasizes the simplicity and efficiency of using Power Query for date conversions.

To transform a date into a text format YY-MM using Power Query, you can use the following M language code:

= Text.From(Date.Year([YourDateColumn])) & "-" & Text.PadStart(Text.From(Date.Month([YourDateColumn])),2,"0")

Replace [YourDateColumn] with the actual name of the column containing the date in your dataset.

This code will extract the year and month from the date column and then format it as "YY-MM" where YY represents the last two digits of the year and MM represents the month. If the month is a single digit, it will be padded with a leading zero.

If you have any further questions or need additional assistance, feel free to ask!

Sources

Power Query date format (How to + 5 tricky scenarios) - Excel Off The GridChanging Date Formats w/Power Query Editor - Simple Technique For Power BI - YouTubeIn Power Query - how to convert dates with a 'MMM-YY' format to a 'MM/DD/YY' format? : r/excel - RedditSolved: Convert a date field to the format "YYYY-MM" AND k... - Microsoft Fabric CommunityFormatting Dates using Power Query - Microsoft CommunityPower Query Date Formats - My Online Training Hub
excel - Powerquery command to convert date format - Stack OverflowPower Query date format (How to + 5 tricky scenarios)

Related Questions

Work fast from anywhere

Stay up to date and move work forward with BrutusAI on macOS/iOS/web & android. Download the app today.

MacOS/iPhone/iPad
App Store
Android Download
Play Store