In this post, we’ll learn different ways to add notes in Power Query, which can benefit the people who do not like to take notes. You can watch the full video of this tutorial at the bottom of this blog. Adding Notes In Power Query: Step Properties The first and easiest one is the feature they
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
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 is 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 can watch the full video of this tutorial at the bottom of this blog. Group By function is the best option when you have
