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 t...
Hi Anonymous ,
you can add a column that counts the distinct values like so:
List.Count(List.Distinct([Transform file][<YourTableNameGoesHere>]))
Working thanks