Tag: power query in power bi

Power Query: How To Quickly Add Notes

Power Query How To Quickly Add Notes - Enterprise DNA

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

Continue reading

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 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

Continue reading