Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In the Query editor I removed double values by Table.distinct(Source, {"Artikelnr"})
But there still are duplicates.
Cannot create a relationship because of duplicate key value.
When I look in the records, there is a value which exist 3 times.
Anyone knows why?
Solved! Go to Solution.
It's about the Uppercase/lowercase
First had to convert the values to lowercase, and then it filters distinct the right way
First thing i'd try is to run a "Trim" operation before removing duplicates. Its possible you have "Artikelnr" and "Artikelnr " which Power BI see's as different.
Next thing to make sure, don't have any blank values in your unique column. Filter those out too.
It's about the Uppercase/lowercase
First had to convert the values to lowercase, and then it filters distinct the right way
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |