Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi Anonymous ,
    you can add a column that counts the distinct values like so:

    List.Count(List.Distinct([Transform file][<YourTableNameGoesHere>]))


ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous ,
you can add a column that counts the distinct values like so:

List.Count(List.Distinct([Transform file][<YourTableNameGoesHere>]))