Level-Up your Power Query game with Custom Functions
Functions are one of the fundamental building blocks of Power Query. In addition to the native ones, we can create our own so that we don't have to write everything repeatedly. Custom functions can be one of your best friends for making your work easier in Power Query. But you need to be able to create them and set the input parameters, including whether they are mandatory or optional. But once we create the function, it doesn't end there! To pass the function to someone or not forget what it does, it is good to know how to add documentation metadata that will be displayed in the preview of the function and used for quick understanding. Start building custom functions and advance your Power Query capabilities. About Speaker: A data lover, especially in the ecosystem of Microsoft tools. I primarily focus on Power BI, Azure Synapse, Azure SQL Microsoft Fabric. In general, I follow a very simple motto (is in Headline). He is a co-founder and a Lead Technical Consultant at DataBrothers.Power BI experts and consultants with a focus on data analysis, reporting, and training in Power BI. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: EnglishTips for Defining Custom Functions in Power Query
Despite the wide variety of functions available in Power Query, sometimes it is necessary to define new custom functions for specific needs, especially in complex data cleansing processes. Online training enables you to become familiar with how to create functions that precisely match your specific conditions and requirements. Defining these specialized functions helps you to clean and prepare your data in a much more accurate and flexible manner, facilitating the optimization of your workflows. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Persian - Persian-Farsi
Batch conversion of headers and column values
Scenario: Suppose I have many columns which both column names and fields look untidy. I want to do some transformations for them in batches. For example, replace multiple spaces as single space and uppercase each first character of word so that the table would look neater.
