Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Duplicate Value Count

Dear All ,   I want to get the count of the duplicate values as shown below. Below shows my table. Predecessr   FollOn Doc 1030172720   1200261222 1030172740   1200261228 1030172...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    2 years ago

    ALLSELECTED has no meaning in a calculated colum.  You can also drop the OrderBy.

     

    Count2 = ROWNUMBER(SUMMARIZE('Table',[Predecessr],[FollOn Doc]),PARTITIONBY([Predecessr]))
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Predecessr"}, {{"All", each Table.AddIndexColumn(_,"Count",1,1), type table [Predecessr=number, FollOn Doc=any, Count=number]}}),
    #"Expanded All" = Table.ExpandTableColumn(#"Grouped Rows", "All", {"FollOn Doc", "Count"}, {"FollOn Doc", "Count"})
in
    #"Expanded All"

Hope this helps.