User Profile
dienursen
New Member
Joined 2 years ago
User Widgets
Contributions
How to Remove Duplicates from PowerBI SQL Direct Query Table
Hello All, I am creating a dashboard using an SQL Database, so there is no Power Query where I can work on an data query. In the dataset I have several alphanumeric IDs with several versions of them. But I need only the last versions of all these IDs. So I need to remove the duplicates of these IDs with the consideration that I need only the last versions. For example, the alphanumeric ID is ABC2010001111, this one has 4 versions, 00, 01, 02, 03. I only need the latest and most updated version to have a reliable dashboard. So ABC2010001111/03 is the one I keep. all others must be removed. Another might have 20 versions, or 2 versions. So there is no point in saying "use always thr 4th version." Any idea how this might work? Thank you in advance, Best regards, NursenSolved481Views0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.