Forum Discussion

Priya_Kulkarni's avatar
Priya_Kulkarni
Frequent Visitor
1 year ago
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. ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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