Forum Discussion
Solved
Time intelligence
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.
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
1 Reply
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