Tag: power query editor power bi

Count Distinct Values In Excel: Classic To Modern Approaches

Count Distinct Values In Excel Classic To Modern Approaches

In this tutorial, I’m going to go through different approaches to how you can count distinct values in Excel from a more traditional way to a more modern technique. You can watch the full video of this tutorial at the bottom of this blog. I’ve got a list of names here, and I want to

Continue reading

Column From Examples Power BI – Power Query Tutorial

Column-From-Examples-Power-BI-–-Power-Query-Tutorial

For today’s blog, I want to share my favorite feature inside the Power Query Editor, by far, which is the Column from Examples Power BI. You can watch the full video of this tutorial at the bottom of this blog. When I look at my data sets now, I always think about how I can

Continue reading

Structured List Value – An Ordered Sequence Of Values

Structured List Value – An Ordered Sequence Of Values

In this tutorial, you’ll learn how to create and utilize structured list values. You’ll also learn how to maximize them using different contexts and expressions to get the desired data and outcome. Shorthand methods will also be discussed to help create lists easily. Creating Structured List Values The list is an ordered sequence of values;

Continue reading

Record Values – Structured Value In Power Query

Record Values – Structured Value In Power Query

This tutorial will discuss about record values inside the Power Query Editor. You’ll learn how to create and use records with different expressions to generate the results you want to achieve. Creating Record Values A record value is an ordered sequence of fields. It is made up of a set of fields that consists of

Continue reading

Center Of Gravity Analysis In Power BI

Center Of Gravity Analysis In Power BI

Finding the center of gravity of a cluster of locations is a common task for people working with Geographic Information Systems. One example is when looking at the allocation of addresses to a depot or engineers to a working area. Although Power BI does not yet support true multiple dynamic layers in the map visuals,

Continue reading