What about the "Cluster Values" Option in Power Bi

[armandogomez]

Hi all

I'm wondering if the "Cluster Values" option in Power Query is still working or if it was deprecated for any reason.

I need to apply this powerful function to a column that contains values that do not all time has the exact value but similar values that I need to solve.

Example:
I have some rows with values like "James", but there are some other rows in the same columns with values like "Jum" or "Jame" and for me, they are the same and need to be treated all these values as James.

If there are any comments, I would appreciate it.

Any idea on how to have the same outcome as this option did to deal with fuzzy values in a column?

Thank you

Armando

[BA_Pete]

Hi Armando,

The Cluster Values column is only available in Power Query online (Dataflows).

Try adding your M code to a Dataflow and using the function there.

Pete