Time intelligence

[Priya_Kulkarni]

Report Week is always Monday. Its working fine till year end.
But for 31st Dec 2024 (As it is Tuesday), it should added to the next Monday i.e. 6th Jan 2025 instead of creating Week 54.

[v-zhouwen-msft]

Hi @Priya_Kulkarni ,

Correct me if I'm misunderstanding.

ReportWeek = 
VAR _monday = WEEKDAY([Date], 2) 
RETURN 
    IF(_monday = 1, [Date],[Date] + 8 -_monday)

Best Regards