Forum Discussion
Remove Duplicates?
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
thanks for reply. The idea behind the data is to record the purchase order details of the fruit. For example, Apple is ID 1, Banana is ID 2, Orange is ID 3. Today the shop ordered 10 apples in 1st of January 2017. However, the supplier only delivered 5 apples in 1st January 2017. So the shop just paid 5dollar to supplier which mean there is another 5dollar is yet to be paid. And then the next day 2nd of January 2017, the supplier delivered another 3apples. Hence the tables will record all the delivery. So what i was asked to do is find out how many and how much of orders and payment are yet to be collected and paid. So technically i should take the latest date of the deliver item. Hope that you would understand what i'm trying to explain here.
This makes sense, now I understand.
To count the Orders just use distinctcount('yourtable'[ID]). To answer your other questions it would be really helpful if you would prepare sample data, and make this data available. This makes it a lot easier for all of us to provide answers to your questions.
Cheers
u can create same tables as screenshot in your power bi. Due to P&C, i cant show u the real dataset.
