In this post, we look at the List.Average Power Query M function. It is one of the average functions in Power Query and returns the mean average of a list. Along with detailed notes, there are 10 examples to show how to use List.Average in… Read More »List.Average in Power Query: 10 easy examples
In this post, we look at the List.Sum Power Query M function. It is an addition function that returns the sum of a list. Along with detailed notes, there are 10 examples to show how to use List.Sum in different contexts. Table of Contents: Purpose… Read More »List.Sum in Power Query: 10 simple examples
In this post, we look at the List.Combine Power Query M function. It is a transformation function that merges a list of lists into a single list. Along with detailed notes, there are 10 examples to show how to use the function in different contexts.… Read More »List.Combine in Power Query: 10 easy examples
With all the functions in Power Query (over 700), it’s hard to believe there are any missing. However, there is no function for List.Unique. I know what the clever ones amongst you will say… “It’s called List.Distinct”. The thing is, unique and distinct are not… Read More »List.Unique is missing: 2 easy to use alternatives
In this post, we look at the List.Distinct Power Query M function. It is a selection function that returns a distinct list of items based on a list supplied. Along with detailed notes, there are 11 examples to show how to use the function in… Read More »List.Distinct in Power Query: 11 Examples
In this post, we look at the List.NonNullCount Power Query M function. It is an aggregation function that counts the number of non-null items in a list. Along with detailed notes, there are 10 examples to show how to use the function in different contexts.… Read More »List.NonNullCount in Power Query: 10 examples
In this post, we look at the List.Count Power Query M function. It is an aggregation function that counts the number of items in a list. Along with detailed notes, there are 10 examples to show how to use the function in different contexts. Table… Read More »List.Count in Power Query: 10 examples
OK, let’s face facts. A lot of data exported from IT systems contain column names intended to be computer-readable, but only partially human-readable. As a result, column names are often in camel case or filled with underscores. We want fully human-readable column names in the… Read More »Easy way to auto rename columns in Power Query
Many like to build Power BI solutions in a development environment with lower data quantities. This means you can develop faster. But anybody who follows this method will soon come to an obvious question when they want to use live data: “how to change data… Read More »5 easy ways to change data source in Power BI
People in finance often need to use foreign exchange rates in their calculations. Since Power BI is the ultimate automated reporting solution, it makes sense to find a way to get FX rates into Power BI as easily as possible. Table of Contents Get FX… Read More »Get FX rates into Power BI: Amazing custom function