Forum Discussion
Changing context of column reference in each statement
Put
Table.Column(Data, [Column])in the brackets for the List.Distinct
It's quite powerful but difficult to find.
In the usage case I hope this will solve, I'm adding some custom columns using Lars Schreiber's article about the second parameter of Table.Profile and I'm using it in a custom function to get a better understanding of any table I pass to the custom function. One of the columns I'd like to create is a list of distinct values for any given text or numeric column that has a limited number of distinct values.
Put
Table.Column(Data, [Column])in the brackets for the List.Distinct
It's quite powerful but difficult to find.
Wow! It was as easy as that! Thanks!
FWIW, I swear I've been over that documentation hundreds of times but I think this is the first time I've used Table.Column! 🙄 Always learning something new! Thanks again!