Forum Discussion

yaman123's avatar
yaman123
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Week End on Thursday

Hi,   I have a query to add a new column to show the week end date from a delivery date field. I have the below dax query but it isnt producing the correct results. The week runs from Fri - Thurs. ...
General Comment
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi yaman123 ,

 

Try this calculated column

Week End =
VAR _weekday =
    SWITCH (
        WEEKDAY ( [delivery date], 2 ),
        5, 1,
        6, 2,
        7, 3,
        1, 4,
        2, 5,
        3, 6,
        4, 7
    )
RETURN
    SWITCH (
        _weekday,
        1, [delivery date] + 6,
        2, [delivery date] + 5,
        3, [delivery date] + 4,
        4, [delivery date] + 3,
        5, [delivery date] + 2,
        6, [delivery date] + 1,
        7, [delivery date]
    )

 

The general rule is to first get the week days that start on Friday and end on Thursday, and then calculate the end date of the week separately.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.