Forum Discussion
Remove Duplicates?
Below are my power bi sample. I am asked to create a dashboard to present the stat of left orders. For examples, i do a calculation: orders= calculate(count(ID)). The result shows there are 5 orders....
Hey,
this is a difficult question, without knowing why there are duplicate records, it's not possible to recommend a way to remove these records.
The ID 1 has 3 records with different dates, for this reason, without more information it's not possible to advise you how to get rid of the duplicate rows (at least I'm not able to do this).
Do you have any idea why there are duplicates?
Can you share sample data, by providing a link to the pbix on onedrive or dropbox?
Regards