Power Query
Parameters and Functions in Power BI / Power Query–Combine Files Experience
I highly recommend that you read the first and second part in this series prior to reading this one, but you can jump right in if you understand the main concepts of parameters, arguments and functions in the M language. Understanding the Combine Files Experience: Practical Example The scenario that we’re going to tackle is […]
Read full article >
Parameters and Functions in Power BI / Power Query–Custom Functions
Power Query has over 600 native functions and the Power Query team keeps adding more and more. I wouldn’t recommend memorizing them, but you do need to understand the concept of parameters and arguments in order to understand what functions are. In this blog post I’ll go over what Custom Functions are and how you […]
Read full article >
Parameters and Functions in Power BI / Power Query – Main Concepts
Power Query or the Power BI Get Data Experience uses a functional language called M to perform its Data Preparation or Data Transformation processes. You can read this article to get to know more about Power Query and the M language, but in short, Power Query is the interface that assists you, through buttons and […]
Read full article >
The most important thing to learn when using Power BI
You’ve started OR you’re in the middle of your Power BI journey and you’re confused as to where you should allocate your learning time and efforts Should it be DAX? Understanding the visualizations? the M language? Power Query? Power Pivot? SOOOO many keywords that appear when doing a simple online search, but WHAT is the […]
Read full article >
Merge Operations in Power BI / Power Query – Part 6: Full Outer Join
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). This is the last post in the series! I highly encourage you to read Part 5 of this series before reading this one, but nevertheless, you can jump right in if you know the basics of Merge […]
Read full article >
Merge Operations in Power BI / Power Query – Part 5: Inner Join
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Similar to the previous posts in this series, I highly encourage you to read the first 4 Parts ( 1 | 2| 3 | 4 ) that I’ve published so far around Merge / Joins inside of […]
Read full article >
Merge Operations in Power BI / Power Query – Part 4: Right Anti Join
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Similar to the previous posts in this series, I highly encourage you to read the first 3 Parts ( 1 | 2 | 3 ) that I’ve published so far around Merge / Joins inside of Power […]
Read full article >
Merge Operations in Power BI / Power Query – Part 3: Left Anti Join
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you haven’t read Part 1 and Part 2 of this series, I highly recommend that you read those prior to this post. In those previous posts, we went over the Left Outer Join and Right Outer […]
Read full article >
Merge Operations in Power BI / Power Query – Part 2: Right Outer Join
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you haven’t read Part 1 of this series, I highly recommend that you read that prior to this post. In that previous post, we went over the Left Outer Join and some basics on how Joins […]
Read full article >
Merge Operations in Power BI / Power Query – Part 1: Left Outer Join
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you’ve used Power Query or Power BI before, you’ve probably seen the “Merge” button which displays a window like the following: and this let’s you join 2 tables (or queries), and one of the questions that […]
Read full article >
Comparing Similar Products (Movies) with Power BI
Back Story: Back in the day, I used to work for this company with a truly all-star / amazing team. We were all part of this company called 20Th Century Fox, and we were in charge of the Theatrical distribution of films in Central America. Business Intelligence wasn’t a standard in the industry – at […]
Read full article >
Clever Filters in Power BI / Power Query with Merge Operations
Have you ever wanted to do a specific type of filter that might be too specific to do with just the regular filter drop down or even the advanced filter operations in Excel? Let me give you an example of one of those scenarios. Imagine that you have a table like the following: [table style=”solid”] […]
Read full article >