Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.