Kumar Shanmugam
Member
I have a file named receipt data with duplicates receipt no. Sample data
RECEIPT_NOBPIS_NOBPIS_VALUE_DATE
C0597141800083SBIN61812736153407-May-18
C04760418013813686790023-Apr-18
C04760418013793686790023-Apr-18
C04760418013813686790023-Apr-18
C04760418013793686790023-Apr-18
I know that we can remove duplicates using power query – simple step.
But I cannot perform the simple step due to the large data model.
I compared the query loading to data model with and without removing duplicates.
It takes hell lot of time when the data is loaded to power query after removing duplicates in power query.
Data loads faster in power pivot if removing duplicates steps not performed in power query.
So after loading the receipt data containing duplicates in power pivot, I created a distinct table with unique receipt no.
RECEIPT_NO
C0597141800083
C0476041801381
C0476041801379
Now I don’t know how to get the additional columns of receipt data in the distinct table. I tried to do with related function but it does not work.
Output required.
RECEIPT_NOBPIS_NOBPIS_VALUE_DATE
C0597141800083SBIN61812736153407-May-18
C04760418013813686790023-Apr-18
C04760418013793686790023-Apr-18
RECEIPT_NOBPIS_NOBPIS_VALUE_DATE
C0597141800083SBIN61812736153407-May-18
C04760418013813686790023-Apr-18
C04760418013793686790023-Apr-18
C04760418013813686790023-Apr-18
C04760418013793686790023-Apr-18
I know that we can remove duplicates using power query – simple step.
But I cannot perform the simple step due to the large data model.
I compared the query loading to data model with and without removing duplicates.
It takes hell lot of time when the data is loaded to power query after removing duplicates in power query.
Data loads faster in power pivot if removing duplicates steps not performed in power query.
So after loading the receipt data containing duplicates in power pivot, I created a distinct table with unique receipt no.
RECEIPT_NO
C0597141800083
C0476041801381
C0476041801379
Now I don’t know how to get the additional columns of receipt data in the distinct table. I tried to do with related function but it does not work.
Output required.
RECEIPT_NOBPIS_NOBPIS_VALUE_DATE
C0597141800083SBIN61812736153407-May-18
C04760418013813686790023-Apr-18
C04760418013793686790023-Apr-18