Month: January 2019

AdoDotNetQuery

M functions documentation within Power Query

Often we look for the documentation of a function or we even look for a function. We may use Microsoft documentation (https://docs.microsoft.com/fr-fr/power-query/). But there is an other way much more comfortable for my needs: access to M functions documentation within Power Query How to Add a blank query and name it ‘Shared’ Open the advanced …

M functions documentation within Power Query Read More »

Duplicates detection in Power Query using different methods

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 …

Duplicates detection in Power Query using different methods Read More »

Visuals test

Visuals test

It’s sometimes useful to compare visuals functionalities. This report is only made for that : compare similar visuals with the Visuals test report. Download the report : Visuals test report More about visuals : Visuals category