duplicate
1 Topic
Summarize Table and Remove Duplicates
I am working with a table of data that I am trying to summarize. For development I am using New Table and Summarizing. I get the first level of summary to work but my table ends up with some duplicate values. Ultimately I want to count the rows that remain after summarizing and removing the duplicate. My Row Count should be 1 for every row. The other option would be to replace the values that are greater than "1" with "1". Any thoughts how I can remove these duplicates without having to setup the table in Power Query? Operation Count by Day = SUMMARIZE('_AELaborEdit - Clock In Date', '_AELaborEdit - Clock In Date'[ClockInDate], '_AELaborEdit - Clock In Date'[Job], '_AELaborEdit - Clock In Date'[Operation], "Operations Count", COUNTROWS('_AELaborEdit - Clock In Date') )Solved5.4KViews0likes5Comments