Duplicate Value

[Anonymous]

Hi everyone,

For some reason when I see my data in power query is as follow

First link for the power bi file

https://intercorpretail-my.sharepoint.com/:u:/g/personal/aleksei_diaz_irdigital_pe/ES5Jjq68cepOqaVxB... 

LInk for the data 

https://intercorpretail-my.sharepoint.com/:x:/g/personal/aleksei_diaz_irdigital_pe/EdhDTwLo5ztBmfB_Y...

[StefanoGrimaldi · Accepted solution]

basically power query seems data as characters meaning OTTOWARE <> Ottoware so power query understand they are 2 different things, if you want to merge those 2 rows as part of a same data you need to do some tranformation such as making all the letters upper or lower case letters and them group them, that would do the trick. 

[Jimmy801 · Accepted solution]

Hello @Anonymous 

Power Query is case sensitive. So whenever you would try to group or doing other transformation, power query will treat both values differently. However when you make a visualation in the desktop both values should be treated as one. So can you check if there are some spaces after the text "Ottoware"? This I think can be the only reason here.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[StefanoGrimaldi · Accepted solution]

basically power query seems data as characters meaning OTTOWARE <> Ottoware so power query understand they are 2 different things, if you want to merge those 2 rows as part of a same data you need to do some tranformation such as making all the letters upper or lower case letters and them group them, that would do the trick.