Go Summarize

Write Your First CUSTOM M FUNCTION in Power BI

How to Power BI2021-04-02
power query#m functions#power query custom function#m functions power query#custom m#m language power bi#power bi m language#m language#power query m#m power query#power bi m#m power bi#m in power bi#learn m#m in power query#custom m function#custom function power query#power bi desktop#how to power bi#datatraining#power bi
25K views|3 years ago
💫 Short Summary

Bas demonstrates the process of creating a custom function for making coffee in Google Sheets, allowing users to input specific parameters and calculate the desired outcomes for brewing coffee.

✨ Highlights
📊 Transcript
Introduction to the custom function for making coffee using the example of brewing coffee.
00:00
The process of grinding beans and brewing water is like mixing and matching functions in code.
The host mentions the possibility of creating a new kind of coffee with advanced editing.
Demonstrates the use of 'info' function and the advanced editor to change the color of the coffee.
Bas introduces the concept of custom functions in a fun and engaging way by creating a function for making coffee.
02:18
Starts with a simple function for making 1 coffee.
Uses the 'if' function to check the number of beans and apply a different operation based on the quantity.
Introduces the 'concatenate' function to combine text strings.
Mentions the importance of not capitalizing certain words in the function.
Bas explains the process of creating a custom function for brewing coffee using the example of calculating the number of coffee beans needed.
04:22
The function calculates the number of beans required based on the strength and type of coffee.
Bas demonstrates how to input the coffee strength and type in the function.
He warns about the case sensitivity in the function and showcases a simple example.
Bas mentions the possibility of adding more complex calculations to the function.
Bas continues to demonstrate the custom function for making coffee, including specifying the type of coffee and the amount of beans needed.
06:18
Uses the 'choose' function to select the type of coffee.
Specifies the amount of beans needed for the chosen type of coffee.
Displays the result for the specified parameters.
Warns about the case sensitivity when entering the parameters.
Bas explores the custom function for brewing coffee further by incorporating additional variables such as the size of the cup and the type of beans.
08:32
The function calculates the amount of water and beans based on the size of the cup and the type of beans.
Bas demonstrates the use of variables and multiplication in the function.
He emphasizes the importance of paying attention to the details and not making mistakes in the function.
Bas mentions the possibility of adding more complex calculations to the function.
Bas concludes the demonstration of the custom coffee brewing function by showing how to use it to calculate the final number of beans for each coffee order.
10:14
Shows how to use the custom function to calculate the final number of beans for each coffee order.
Mentions the potential for more complex transformations with the custom function.
Encourages viewers to check out the networking workshop for more information.
Demonstrates the ease of using and copying over the custom function for future use.
💫 FAQs about This YouTube Video

1. What is the video about?

The video is a tutorial on how to create a custom function for making coffee using Google Sheets. The demonstration showcases the process of defining and implementing the custom function, allowing users to input specific parameters and calculate the desired outcomes for brewing coffee.

2. How does the tutorial introduce the concept of custom functions?

The tutorial introduces the concept of custom functions by likening the process of making coffee to mixing and matching functions in code. It starts with the basic idea of grinding beans and brewing water, and then progresses to more advanced editing and function use.

3. What examples are used to explain the custom function?

The examples used to explain the custom function include creating a new kind of coffee with advanced editing, changing the color of the coffee using the 'info' function and the advanced editor, and demonstrating the use of functions for brewing coffee.

4. How does the host demonstrate the use of custom functions in the video?

The host demonstrates the use of custom functions by showing how to create a custom function for making coffee, use the 'if' function to check the number of beans, apply different operations based on the quantity, and introduce the 'concatenate' function to combine text strings.

5. What is the key focus of the tutorial on custom functions?

The key focus of the tutorial on custom functions is to showcase their practical application in the context of making coffee. The video demonstrates how custom functions can be used to streamline and automate processes, providing a clear and accessible example for viewers to understand and implement in their own projects.