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
Tag: power query in power bi
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
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
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
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