fuzzy grouping

[hgorina]

I am trying to group text based on fuzzy matching
my initial approach was to group based on full match, but I have realised that this gigantic dataset is not consistent

[v-shex-msft]

Hi @hgorina,

Your snapshot seems broken, can you fix it with some sample data to help use clear your data structure?

How to Get Your Question Answered Quickly

You can also take a look at following link to know how to achieve fuzzy string compare based on dax formula:

From SQL to DAX: String Comparison

Regards,

Xiaoxin Sheng

[hgorina]

sample fuzzy matches
Thanks for responding
the dataset is huge, and it comes from the zipped log files from some software chashes, I cannot do anything with sql query and i think DAX will be way too slow. I am trying to work on the query level.

the goal is to find similar lines - they may have various numbers and verbalization, but they explain a reason for the crash, which I want to quantify

thanks again

[v-shex-msft]

HI @hgorina,

I think you need to create a calculated column to extract and store particular error message text.

Then you can create a dictionary table with some keywords which used to compare with extracted error message text and as group category label.

If you still confused on coding formula, can you please share some sample data with same data structure so that we can test to coding formula?

Notice: please do mask on sensitive data before share.

Regards,

Xiaoxin Sheng