Skip to content
Small logo
  • Our services
  • The BI Power toolsExpand
    • Power BI Sidetools
    • Power BI assistantExpand
      • Power BI assistant
      • Power BI assistant troubleshooting
  • Power BI desktopExpand
    • Report filters
    • Translations
    • Export data
    • Visuals
    • Tooltips
    • Actions within reports
    • Futurist features
    • Other
  • Power Query
  • LinksExpand
    • Blogs, Web sites, videos
    • Power BI trainings
    • Tools
    • Power BI model documentation for free
    • Q&A
    • Visuals
    • R scripts
Twitter Linkedin
Small logo

duplicates

Duplicates detection in Power Query using different methods
Power Query

Duplicates detection in Power Query using different methods

ByDidier TERRIEN 20 January 201916 December 2020

As duplicates are a nightmare in databases, I wrote a function to identify them between two tables. Duplicates detection in Power Query is extremely useful for data consistency. Additionally, it helps to avoid relationships isues. You may also use the same function with only one table. The function is optionally insensitive to case, separators and…

Read MoreContinue

Categories

  • Power BI assistant
  • Power BI desktop
    • Actions within reports
    • Export data
    • Futurist features
    • Other
    • R
    • Report filters
    • Tooltips
    • Translations
    • Visuals
  • Power BI Sidetools
  • Power Query

Tags

augmented reality compare columns data database data cleansing data matrix data profiling db scheme dedupe distinct documentation duplicates excel export external tool filters hololens interactions issue m map model powerapps power bi assistant power bi desktop power bi sidetoools power query R refresh date roadmap search shared slicers table tooltip translations troubleshooting tutorial url username visuals visual studio code
Search

Popular posts

  • Easily export to Excel with Power BI Sidetools
  • Compare DAX and M formulas in Visual Studio Code
  • Automatic translation of visuals labels
  • 1. Add a filter page to your report

  • About
  • Contact
  • Subscribe
  • Sitemap

© 2021 The BI Power

Small logo

 

Scroll to top
  • Our services
  • The BI Power tools
    • Power BI Sidetools
    • Power BI assistant
      • Power BI assistant
      • Power BI assistant troubleshooting
  • Power BI desktop
    • Report filters
    • Translations
    • Export data
    • Visuals
    • Tooltips
    • Actions within reports
    • Futurist features
    • Other
  • Power Query
  • Links
    • Blogs, Web sites, videos
    • Power BI trainings
    • Tools
    • Power BI model documentation for free
    • Q&A
    • Visuals
    • R scripts