Help with Syntax Error

[CC852]

When I use the syntax below:

Week Ending =

DatesTable[Date]

    - MOD ( DatesTable[Date] – 1, 7 ) + 6

I get the error: 

The following syntax error occurred during parsing: Invalid token, Line 3, Offset 30, –.

How can I fix this? - thank you in advance!

[audreygerred · Accepted solution]

If you are trying to create a calculated column for week ending date, try the below:

WeekEndingDate =

    'Date'[Date] + (7 - WEEKDAY('Date'[Date], 2))

This formula calculates the week ending date (assuming the week ends on Sunday) for each row in the table. The WEEKDAY function returns the day of the week corresponding to a date, with the day numbering starting from Monday (when the second argument is 2). The result is then subtracted from 7 to get the number of days until the end of the week, which is added to the original date to get the week ending date.

Below is the test I have completed:

[CC852]

Wow, thank you so much!

I made an edit to your syntax (from 2 to 1) since I need weeks to end on a Saturday.

Week Ending =

    'DatesTable'[Date] + (7 - WEEKDAY('DatesTable'[Date], 1))

[audreygerred]

You're very welcome! Happy to help! Please mark as a solution so others are able to find it to help in the future. Have a great week!