Group By fx in PBI Power Query does not group all duplicates as with Excel Power Query.

Hi jzadok,

Thanks for sharing your custom trim function, that is a great approach. If you are still seeing differences, it is usually due to hidden characters or casing that Excel strips but Power BI keeps. You can try wrapping your column with:

Text.Upper(Text.Clean(Text.Trim([YourColumn])))

This should standardize spaces, remove hidden characters, and align grouping with what you see in Excel.

Let us know if that works out. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.