Power BI is a powerful data visualization and business intelligence tool that allows users to connect to various data sources, create interactive reports and dashboards, and share them with others. In today’s blog, we will be exploring the most powerful function call in Power BI. This function call will greatly enhance the capabilities of Power BI
In this tutorial, you’ll learn how to reference tables in Power Query to improve refresh time and data performance in Power BI. You can watch the full video of this tutorial at the bottom of this blog. Power Query has an option to set the refresh frequency for a query by selecting the “Refresh every”
This tutorial will demonstrate how to use the COALESCE operator in Power Query / M language by examining two practical problems. You can watch the full video of this tutorial at the bottom of this blog. The COALESCE operator is represented by a double question mark (??). This operator works similarly to the or operator
In today’s blog, I will briefly introduce the Extended Date Table 2.0. I first shared the code for this M function in April 2020. Since then, there have been a number of requests and updates on this Power Query date table. You can watch the full video of this tutorial at the bottom of this
Power Query is a data transformation and manipulation tool that’s available in Microsoft Excel and Power BI. It has a wide range of functions that can be used to transform and manipulate data. In this tutorial, you’ll learn how to use the each expression in Power Query / M Language. You can watch the full
