Power Query Tips and Tricks: What You May Not Know
Are you a Power Query user looking to level up your skills? Join us for this session where we'll dive into some of the lesser-known Power Query tips and tricks. We'll start with an introduction to Power Query and then cover some specific tips, including table projection, referencing middle steps in other queries, solving the problem of repeat function names, cheating in using functions, dealing with two or more headers, and converting Persian number characters to their normal equivalents. We'll also show you how to solve one of Excel BI's challenges using Power Query. Whether you're a beginner or an experienced user, you'll leave this session with a deeper understanding of Power Query's capabilities and how to use them to streamline your data cleaning and analysis workflows. Don't miss out on this opportunity to learn from our experts and take your Power Query skills to the next level. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Persian - FarsiPower Query Tips and Tricks: What You May Not Know - Part 2
The second part of Mahmoud's Power Query Tips and Tricks series. Are you a Power Query user looking to level up your skills? Join us for this session where we'll dive into some of the lesser-known Power Query tips and tricks. We'll start with an introduction to Power Query and then cover some specific tips, including table projection, referencing middle steps in other queries, solving the problem of repeat function names, cheating in using functions, dealing with two or more headers, and converting Persian number characters to their normal equivalents. We'll also show you how to solve one of Excel BI's challenges using Power Query. Whether you're a beginner or an experienced user, you'll leave this session with a deeper understanding of Power Query's capabilities and how to use them to streamline your data cleaning and analysis workflows. Don't miss out on this opportunity to learn from our experts and take your Power Query skills to the next level. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Persian - FarsiLevel-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: English
