Forum Discussion

Kent1341's avatar
Kent1341
Icon for Helper I rankHelper I
4 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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 .