Forum Discussion

naveen73's avatar
naveen73
Icon for Helper III rankHelper III
2 years ago

Generate column with count of values

Hi all,   I am working with a dataset and merging another set and applying filters. At some point I am getting the “Value” column (see screenshot). However, the values are a sum of each of the “Pr...
Need Help
naveen73's avatar
naveen73
Icon for Helper III rankHelper III
2 years ago

Hi wdx223_Daniel 

Thanks for your efforts. I was looking for a solution in M language. Would you (anybody) be able to help me with in M. Perhaps it is technically not possible in M?

 

Thanks,

 

Naveen

  • spinfuzer's avatar
    spinfuzer
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Right Click on the Column(s) You want to group by --> Group By --> Operation --> Count Rows

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    2 years ago

    =Table.Combine(Table.Group(YourTableName,"Product Code",{"n",each let a=Table.RowCount(_) in Table.AddColumn(_,"Custom",each [Value]/a)})[n])