Hi All,

I am looking for help in identifying the First Occurrence of Customer ID in my data table.

I want to build a custom column to mark all first occurrence as "1" and others as "0"

We need to compare the Date_Time column to see which row qualify's first as there will be several duplicate records for each day.

Any Ideas appreciated.