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