Keep trailing spaces at the end of the cells

[vibhoryadav23]

Hi,

I have two similar cells, one with trailing space at the end. Example: "Spain" and "Spain "

When I load the data in Power Query, I can see these two as different rows and if I do remove duplicates, it keeps both the rows. But when I import the same in a pivot or try to create a relationship, it clubs them together and shows as duplicates. 

Does someone knows a way to handle this issue. I want them to be treated as two different cells.

Thanks in advance!

[v-stephen-msft]

Hi @vibhoryadav23 ,

How about replace "Spain1" with "Spain "?

Replace values (Power Query)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vibhoryadav23]

This will require a lot of manual intervention as  there are a lot of duplicate values in my data and the duplicates change over time. I need a solution which automatically takes these cases into account.

[vibhoryadav23]

@ribisht17 

This workaround doesn't work for me as I need to create a realtionship on the same column as well

[ribisht17]

@vibhoryadav23 

Please find my post here Re: Include duplicates in slicer - Microsoft Power BI Community

Thanks,

Ritesh