Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
Proud to be a Datanaut!