Many thanks for your help.
the date can be random dates and not sequencial as my example.
so how can i remove the date column and change it to an incremental number 1,2,3,4,5.
I have not used the date dimension in the data. So, it shouldn't matter whether they are random or sequential.