Forum Discussion
Advocate IHow do I show/export rows that are identical?
I have the following csv:
A,B,C,D
2017-09-29 00:00:00,OMEGA ,AB ,19
2017-09-29 00:00:00,OMEGA ,AB ,20
2017-09-29 00:00:00,OMEGA ,AB ,22
2017-09-29 00:00:00,OMEGA ,AB ,19
2017-09-29 00:00:00,OMEGA ,AB ,19
2017-09-29 00:00:00,OMEGA ,AB ,19
If I create a table in a report it will look like this:
Is there any way for me to see all the rows (even the duplicate ones) and how do I do if I want to export them?
Best regards,
Mattias
Matjo add an index to the line, ie add column / index column in power query , that will make each line unique then add the index to your table visual table
or you could add a group by or count column to tell you how many rows there are of the same. so add a measure countrows(tablename) and then add the measure to the table that tells you how many you have of each row
1 Reply
- vanessafvg
Community Champion
Matjo add an index to the line, ie add column / index column in power query , that will make each line unique then add the index to your table visual table
or you could add a group by or count column to tell you how many rows there are of the same. so add a measure countrows(tablename) and then add the measure to the table that tells you how many you have of each row