Get minimum date value in week group based on WEEKNUM

[olimilo]

Given the sample data below:

Date		WeekNum
1/1/2023		1
1/2/2023		1
1/3/2023		1
1/4/2023		1
1/5/2023		1
1/6/2023		1
1/7/2023		2

WeekNum is a calculated column using WEEKNUM(). Is it possible to create a calculated column that says the "Week of" with the first date of that week?

Date		WeekNum			Week Of
1/1/2023		1			Week of 01/01/2023
1/2/2023		1			Week of 01/01/2023
1/3/2023		1			Week of 01/01/2023
1/4/2023		1			Week of 01/01/2023
1/5/2023		1			Week of 01/01/2023
1/6/2023		1			Week of 01/01/2023
1/7/2023		2			Week of 01/07/2023

[Dhairya]

Hey @olimilo 
You can create the calculated column with the below DAX to get the expected output.

Minimum in week col =
CALCULATE(
    MIN(TableA[Date]), 
    ALLEXCEPT(TableA,TableA[WeekNum])
)

If this helps you then please kudo my reply and mark it as accept as solution so that others cabn find it quickly while facing the similar issue. Thank You!

[olimilo]

This worked for me but I also found a different solution:

WeekOf = 
    CALCULATE(
        "Week of " & FORMAT(MIN('Data'[DATE]), "YYYY-MM-DD"),
        FILTER(
            'Data',
            'Data'[WeekNum] = EARLIER('Data'[WeekNum])
        )
    )