DAX Add Index Column that groups by week and sorts by date

[hnblann]

Hello, I'm trying to create an index column, where when the data is grouped by week, and the pickup date is in ascending order, the index reads 1, 2, 3, 4, etc. and that starts back over at 1 for the next week.

How would I go about doing that?

 

[Greg_Deckler]

@hnblann This solves everything except how to resolve ties between duplicate dates. PBIX is attached below signature.

Column = 
    VAR __Date = [Date]
    VAR __Week = [Week]
    VAR __WeekTable = FILTER(ALL('Table2'),[Week] = __Week)
    VAR __TextTable = CONCATENATEX(__WeekTable,[Date] * 1.,"|",[Date])
    VAR __Table = 
        ADDCOLUMNS(
            GENERATESERIES(1,COUNTROWS(__WeekTable),1),
            "__Date", PATHITEM(__TextTable,[Value])
        )
RETURN
    MAXX(FILTER(__Table, [__Date] = (__Date * 1.) & ""),[Value])