Forum Discussion

Asmilinich25's avatar
Asmilinich25
Regular Visitor
3 years ago

Creating a Distinct Column Count of a Column Based on Another Column Data

Hi All,  I have been struggling to find the solution for this. I have an imported data set where column one has a unique identifier that may be repeated for multiple rows. The other column I have is...
Need Help
KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
3 years ago

Hi Asmilinich25 ,

 

Add a custom column and add the code below:

*replace the #"Changed Type" with your previous step name.

Table.SelectRows( 
   Table.Group(
      #"Changed Type", 
      {"Unique Identifier"}, 
      {
        {"Count", 
         each Table.RowCount(Table.Distinct(_)), 
         Int64.Type}
      }
   ), 
   (x)=> [Unique Identifier] = x[Unique Identifier] 
)[Count]{0}

 

Regards

KT