Tag: power query in power bi

Distance And Bearing Calculation: Power BI Geospatial Analysis

Distance And Bearing Calculation- Power BI Geospatial Analysis

This tutorial aims to discuss how to calculate distance and bearing in Power BI and how to efficiently use them for geospatial analysis. You can find a lot of distance calculations on the web. For this demonstration, I’ll use a simplified example of a solution I needed to build for one of my supply chain

Continue reading

Power Query Function In Power BI: Group By Function

Power Query Function In Power BI: Group By Function

This tutorial will be about a power query function in Power BI called Group By. It’s an underrated feature in Power BI that lets you solve common problems in the simplest way possible. You may watch the full video of this tutorial at the bottom of this blog. Group By function is the best option when

Continue reading

How To Merge Queries In Power BI

Merging is another powerful transformation to optimize our tables and information that we might be getting from various sources. Learning how to merge queries in Power BI is relevant as this transformation can simplify our data models. Getting data from different sources in Power BI isn’t a big issue. It doesn’t really matter where the data comes from since they will just become a query. What

Continue reading

How To Append Power Queries In Power BI

Appending queries

In this tutorial, we’re going to learn how to append power queries in Power BI. This technique is the process of layering one thing on top of the other. I’m going to show a perfect example as to why we need to do this. In the tutorial that I made for staging queries, we created

Continue reading

Referencing And Duplicating Queries In Power BI

Referencing And Duplicating Queries In Power BI

Referencing and duplicating are two different actions. In this tutorial, we’re going to discuss the difference between referencing and duplicating queries in Power BI. Right click on anything in the Queries pane. Then, we’ll see that we have Duplicate and Reference options. One of the differences between Reference and Duplicate is what happens inside the

Continue reading