As you can see, the function takes a date value as its input (which we have named "Date" in this case) and then calls the built-in Date.Month function to extract the month from the date. That's it! With this simple code, you can create your own Date.Month function in Power Query.

Using the Date.Month Function in Power Query

Now that you understand the M code behind the Date.Month function, let's look at how you can use it in your own Power Query projects. Here is an example of how to use the Date.Month function to extract the month from a date column in a table:

1. Open Power Query and load the table that contains the date column.

2. Select the date column and click on the "Add Column" tab.

3. Click on "Custom Column" and enter the following formula:

4. Click "OK" to create the new column.

This will create a new column in your table that contains the month value for each date value in the original column.

In conclusion, the Date.Month function is a powerful tool in Power Query that allows you to extract the month from a date value. By understanding the M code behind the function, you can create your own custom functions in Power Query and tailor them to your specific data needs. With this knowledge, you can take your data analysis skills to the next level and become a true Power Query expert.

Power Query and M Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us