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
Power Query: Insert Sum Rows for Dynamic Periods
Scenario With my experience of using Power BI, many users want to insert a sum row into the data table instead of using the grand total feature in the table/matrix visual. However, Power BI does not support inputting rows into columns by DAX method. Therefore, I would like to introduce the way to insert rows in query editor with further extension of adding multiple rows to sum up the previous N daysโ data. It is important to note that the method is only suitable if you would like to insert roles to the existing column. As the result, the date hierarchy would become invalid that may affect the creation of report, this is because adding the sum rows would change the column type from Date/Time to Text.
