To have data sorted the same, in Data view, as it's in Editor

A data structure as below.

(the .pbix file is here: https://we.tl/t-l4vagf7oXc )

I need the data in Data view to be sorted by “Project” and “Attend Date” (first date then time), to suit some formula.

Steps taken in Advanced Editor:

(the column “Attend Date” is texts)

1. Duplicated the column “Attend Date”, and split it by delimiters, to create 2 new columns – “Attend Date (mm/dd/e)” and “Attend Date (time)”.
2. The data was sorted by 1. “Project”, 2. “Attend Date (mm/dd/e)”, 3. “Attend Date (time)”.
3. Then, an index column starting from 1, was added to the data.

In Advanced Editor, it looks like the data is sorted by the Index column (1,2,3,4,5…) which was by “Project” and “Attend Date” (first date then time).

When Closed and Applied, however it is not the same sorting in Data view.

As there are some formula requires the data sorted. How can I sort the data in Data view, by “Project” and “Attend Date” (first date then time). Thank you.