I have a table containing 3 million or so transaction records.
I need to find for the unique customer ID’s in this table and generate another table containing all the unique customer ID’s. I need this list to filter out some other data
So, what I’m doing now is duplicating this table, removing all the columns except the Customer ID column and then doing a remove duplicates in Power Query. That does not work for me Power BI never comes back and just spins endlessly with getting the results I wanted. Meaning a table (query) with just my unique Customer ID’s from my 3 million + transaction table.
There must be a better way to get all my unique Customer ID’s from a 3 million + table.
What should I do ?
Eric (Montreal, Canada)