The key requirement is to create a calculation that is independent of locale settings. The DATEPART function with the iso-weekday part meets this requirement. It adheres to the ISO 8601 standard, where the week consistently starts on Monday (1) and ends on Sunday (7).

In this standard:

Saturday is always represented by the integer 6.

Sunday is always represented by the integer 7.

Therefore, the expression DATEPART('iso-weekday', [Order Date]) >= 6 correctly and efficiently identifies both Saturday and Sunday, regardless of any regional or data source settings for the start of the week.

A. The DATEPART('weekday', ...) function's result depends on the data source's configured start of the week, making it unreliable across different locales.

C. The DATENAME function returns a string (e.g., "Saturday"), which causes a type mismatch when compared numerically with >= 6.

D. This expression checks if the day is Monday (iso-weekday = 1) or Sunday (iso-weekday = 7), which does not match the requirement to identify Saturday and Sunday.

1. Tableau Official Documentation

"Date Functions": This document details the behavior of date functions used in Tableau and related Salesforce Analytics products.

Section on DATEPART(datepart

date

[startofweek]): It specifies that 'iso-weekday' returns the weekday as an integer from 1 to 7

where Monday is 1. This confirms that Saturday is 6 and Sunday is 7. It also clarifies that the standard 'weekday' part is dependent on the [startofweek] parameter

making it locale-sensitive. (Accessed via Tableau Help portal).

2. Salesforce Help

"Tableau CRM Functions in Data Prep Recipes": While syntax can vary

the principle of using standardized functions for consistency is a core concept. The ISO 8601 standard is the universal solution for locale-independent week calculations. The use of iso-weekday in the question points directly to the Tableau function set

which is part of the ANALYTICS-CON-301 curriculum.