Comparing Groups for Similarities in Power Query – Using Cosine Similarity
Recently, my skills were put to the test when I needed to compare hundreds of Active Directory and SharePoint Groups to find similarities in their memberships.
2025-01-10
Recently, my skills were put to the test when I needed to compare hundreds of Active Directory and SharePoint Groups to find similarities in their memberships.
2025-01-10
This article looks at ways to clean up text data used in Power BI reports and charts for a more meaningful and consistent message.
2023-10-27
This article introduces M language concepts and examples of using M to manipulate data in Excel.
2023-10-02
This article employs Power Query features to combine queries and implement requirements in different listed scenarios.
2023-08-07
There is a Power Query activity in SSIS and Azure Data Factory, which can be more useful than other tasks in some situations.
2021-07-26
4,374 reads
In this article we walk through an example of using Power Query to transform source data that can be used in a Power BI report.
2021-04-21
When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]
2021-01-25
16,825 reads
Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not robust and not reusable. In order to reuse the same piece of code, […]
2020-04-21
41,084 reads
Problem Many of us are already aware of the loopin...
2020-04-07
8,448 reads
Koen Verbeeck shows how to easily extract metadata from files in your directories with Power Query.
2015-09-23
3,175 reads
I have a few clients that incrementally load tables from a SQL Server source...
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
By James Serra
As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...
Comments posted to this topic are about the item Why you should avoid Implicit...
Comments posted to this topic are about the item JSON in Microsoft SQL Server:...
I have this number: 456.23 What is the scale of this number?
See possible answers