The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!