Forum Discussion
Count distnict values in table before expand it
Hi this is what I want to do is count unique values based on one column before expand the table.
I need this because there are so files that should not be included from today and the most easy way to fit solution to already existing query is just unfilter some files that will have too many unique in my specific column.
Any solution how to do it?
Hi Anonymous ,
you can add a column that counts the distinct values like so:
List.Count(List.Distinct([Transform file][<YourTableNameGoesHere>]))
2 Replies
Hi Anonymous ,
you can add a column that counts the distinct values like so:
List.Count(List.Distinct([Transform file][<YourTableNameGoesHere>]))