Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Matjo
Advocate I
Advocate I

How 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: 

Table example.png
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

1 ACCEPTED SOLUTION
vanessafvg
Super User
Super User

@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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

1 REPLY 1
vanessafvg
Super User
Super User

@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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.