Forum Discussion

jzadok's avatar
jzadok
Frequent Visitor
11 months ago
Solved

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

All - I have been doing some research on a Group By issue and have yet to find a solution...In Power BI, when performing the Group By function, I find that not all the duplicate values are uniquely g...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    11 months ago

    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.

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
11 months ago

Your thinking is right as Power Query is the same in both Excel and Power BI

 

Can you please share your input file so I try to reprodice the problem?

 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI