Tag: power query in power bi

Merge Queries Using Anti Join In Excel With Power Query

Compare And Merge Queries Using Anti Joins In Power BI

Automating your data filtering and cleaning processes can be such a huge time saver. For today’s tutorial, I’m going to demonstrate how you can compare and merge queries by using Anti Join in Excel with Power Query. You can watch the full video of this tutorial at the bottom of this blog. Let me start

Continue reading

Power Query: Combine Files from Multiple Folders

Power Query Combine Files from Multiple Folders

For this post, we’ll be doing work in power query, combine files from multiple folders in our network, desktop, OneDrive, or SharePoint. In this example, we have three CSV files in a folder and the data looks like this: We will be using power query in Excel, which works exactly the same as power query

Continue reading

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

how to merge queries in power bi post image

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