Forum Discussion
Relationships Issue
Oops, change COUNTROWS to COUNT.
emma313823 if you removed the duplicates in power query, it sees different cases of the same value as different values
best thing to do is to standardize everything into one case, then remove duplicates
however i think null or blank values can also create issues so pad them with a default value like na or unknown
The list of unique part numbers is in excel and I used 'get data' for this. This spreadsheet is updated regularly, so it is easier to have the spreadsheet get updated then refresh the dashboard.
When you use Get Data to connect to an Excel sheet you can add a step that removes duplicates. Have you not done this?
Seriously try my check. You will see that there are duplicates.
No didn't know I could do that...I removed duplicates using excel. I will try this.
