When building a view, you want a new field that displays the full month name (January, February, etc.) from the Order Date dimension. Which of the following formulas should you enter when creating a calculated field to produce that result?
DATENAME returns the name of a specified part of a date as text. Using DATENAME('month',[Order Date]) converts each date to its month name, exactly as required. DATETRUNC('month',[Order Date]) keeps the date data type and simply rounds each date down to the first day of its month. DATEPARSE is intended for converting text to dates, not the other way around, and the syntax shown would error. STR([Order Date],'month') is not a valid Tableau function combination. Therefore, only the DATENAME formula meets the goal.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the difference between DATENAME and DATETRUNC in Tableau?
Open an interactive chat with Bash
When should DATEPARSE be used in Tableau?
Open an interactive chat with Bash
Why does STR([Order Date], 'month') not work in Tableau?
Open an interactive chat with Bash
Tableau Desktop Foundations
Exploring and Analyzing Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .