Forum Discussion
Sorted Import from Flat File
Hi I receive flat files once a month over the last 2 years' sales. However, there might be some changes to the data that have occurred since the last time I got the data. Therefore I need to mak...
For that to work you need two data points
- a unique transaction identifier
- a "modified" timestamp for each row (unless you can proxy that with the file name or file date for your files)
I would recommend against any attempt at sorting. Handle it via DAX .