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