“Clustering text values in Power BI” - Ilgar Zarbaliyev's Nuzzel Newsletter for Thu, Sep 3

The August 2020 release of Power BI Desktop includes a new Power Query function: Table.AddFuzzyClusterColumn. This function allows you to clean, cluster, or group text values. In this blog post I'm showing an example of how it works. Let's say you…

Home - Blog - How to Delete All Hidden Rows and Columns in Excel A lot of Excel users hide rows and columns when they have some data that they don't need visible. It's a way to only keep useful data visible, and at the same time not have to delete…

How cool would it be to not have to manually update your dataset to keep data for last 2 Years (last year and this year to the current date)? In this blog post I will show you how you can easily filter dates in Power Query to show dates for last…

One aspect of building a data culture is selecting the right tools for the job. If you want more people working with more data, giving the tools they need to do that work is an obvious requirement. But how many tools do you need, and which tools…

Shared by…

5

More info…

This article contains a shorter technical description of the requirement and of the solution, and a longer explanation of the reasons why the solution proposed is required and why other approaches may fail. If you are familiar with calculation…

Shared by…

4

More info…