Adding description to time measure

Hi  njxfoster ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Week = WEEKNUM('Table'[Date],2)

mindate =
var _weeknum=WEEKNUM('Table'[Date],2)
var _weekday=WEEKDAY('Table'[Date],2)
return
MINX(FILTER(ALL('Table'),'Table'[Week]=EARLIER('Table'[Week])),[Date])

Flag = "Week of" &" "& MONTH('Table'[mindate])&"/"&DAY('Table'[mindate])

2. Add Column – Index Column – From 1.

3. Create calculated table.

Table2 =
SUMMARIZE('Table','Table'[Flag],"Index",MINX(FILTER(ALL('Table'),'Table'[Flag]=EARLIER('Table'[Flag])),[Index]))

4. Join the relationship between two tables.

5. Column[Flag] – Column tools – Sort by column -- [Index] .

6. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly