There are a number of List transformations available in Power Query’s graphical interface. However, the number of functions in the graphical interface is very limited. In this post, I’m going to explain about a function that is really powerful and is not yet listed in the graphical interface. List.Accumulate is a function that loops through Read more about List.Accumulate Hidden Gem of Power Query List Functions in Power BI[…]
A couple of months ago, I’ve written a blog post about Basics of M and explained few basics about this language. In this post, I’m going to the next step and will explain few other structure definitions in this language. In this post, you will learn about Tables, Records, Lists, and how to navigate through Read more about Basics of Value Structures in M – Power Query Formula Language[…]
In last two steps you learned how you can create a date dimension that has calendar columns, and fiscal columns. In this step we are going to look at how Power Query can be leveraged to fetch public holidays live from APIs, and add that information into the date dimension. This step shows the importance Read more about Create a Date Dimension in Power BI in 4 Steps – Step 3: Public Holidays[…]
In step 1 of creating date dimension I explained how to create the base query with calendar columns. In this post I will explain how to add fiscal columns calculated in the date dimension. Many of business reports generates on fiscal year, fiscal quarter, and fiscal period, so having fiscal columns is important part of Read more about Create a Date Dimension in Power BI in 4 Steps – Step 2: Fiscal Columns[…]
I have written multiple blog posts so far about creating a date dimension. However, I still get the question about how to create a date dimension. In this series of blog posts I am going to explain in details how you can create a date dimension easily in Power BI (based on Power Query). this Read more about Create a Date Dimension in Power BI in 4 Steps – Step 1: Calendar Columns[…]
Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch Read more about Solving DAX Time Zone Issue in Power BI[…]
One of the recent features in Power BI Desktop is the ability to create your own custom connector and use it when connecting to the data source. This feature looks just one feature, but it opens doors to many possibilities. With this feature you can write your own custom connector to any types of data Read more about Power BI Custom Connector: Connect to Any Data Sources. Hello World![…]
Previously I have written a blog post explaining two ways of combining data sets with each other; Append vs Merge. In this post I want to explain in details what is the difference between all types of Merge Type and explaining how to choose the right merge (or Join) type. These Merge types are very Read more about Choose the Right Merge Join Type in Power BI[…]
There are some traditional problems in most of industries like how we can reach maximum profit, sales, production or how we can minimize our cost and loos. These types of problems can be seen in different areas such as microeconomic and company management, such as planning, production, transportation, technology . Although the modern management issues Read more about Optimization Problem in Power BI using R scripts: Part1[…]
M is the powerful language behind the scene of Power Query. Any transformation you apply will be written in M language. For many, M looks like a scary language. In this post I like to explain a bit of basics of M. Not mentioning any functions. Mainly I want to explain to you how the Read more about Basics of M: Power Query Formula Language[…]