DAX help for max date of each week

[SonaSinghA]

Hi Experts,
Need to calculate max date for each week. The below formula is working fine except for the week of January.
Please help

Reporting Period = CONCATENATE(YEAR(Calendar[Date]) & " W-", Calendar[Iso Week])

Max Date =

VAR GroupBy = Calendar[Reporting Period]

RETURN

MAXX(

FILTER ( ALL(Calendar), Calendar[Reporting Period]=GroupBy),

Calendar[Date])

[PijushRoy · Accepted solution]

Hi @SonaSinghA 

Please find the DAX for Measure

MaxDateOfWeek = 
VAR WeekSummary =
    SUMMARIZE(
        'Date',
        'Date'[WeekNumber],  
        "MaxDate", MAX('Date'[Date]) 
    )
RETURN
    MAXX(WeekSummary, [MaxDate])

PBIX

https://drive.google.com/file/d/1m3Ufne7cm3eIWlMO56XJd51NA3QMjxtx/view?usp=sharing

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin