Exam TDA-C01 topic 1 question 106 discussion

Actual exam question from Tableau's TDA-C01

Question #: 106
Topic #: 1

DRAG DROP
-

You have the following calculated fields in a worksheet.

[Calc1] = DATEADD (‘year’, -1, TODAY ())

[Calc2] = DATETRUNC (‘month’, DATEADD (‘year’, -1, TODAY ())

You want to calculate the month to date value of the prior year.

How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

Show Suggested Answer

Suggested Answer:

by Lakshmi2023 at Jan. 15, 2025, 7:09 p.m.

Comments

Submit Cancel

AmieM

2 months ago

Answer is correct. Calc 2 first to truncate to the first day of the last year's month (month start) and then Calc 1 for today's date last year (month to date end). This will correctly capture all dates from the start of the month last year up to the same day last year, giving you prior year MTD values

upvoted 1 times

...

Lakshmi2023

10 months, 2 weeks ago

Tested. The correct answer is First option : Calc1 Second option : Calc2

upvoted 2 times

janasuresh

10 months ago

Can you please explain

upvoted 1 times

2ec454a

3 months, 3 weeks ago

It is somehow ambiguous, but the request is for previous year not current

upvoted 1 times

...