Forum Discussion
Duplicate Value
Hi everyone,
For some reason when I see my data in power query is as follow
First link for the power bi file
LInk for the data
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.
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
2 Replies
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.
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