Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Analytics-DA-201 Exam - Topic 1 Question 16 Discussion

You have the following dataset.Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
B) (SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )
A) (SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))
C) (SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))
D) (ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )

Salesforce Analytics-DA-201 Exam - Topic 1 Question 16 Discussion

Actual exam question for Salesforce's Analytics-DA-201 exam
Question #: 16
Topic #: 1
[All Analytics-DA-201 Questions]

You have the following dataset.

Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?

Show Suggested Answer Hide Answer
Suggested Answer: B

The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year's sales, and then divides this by the previous year's sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter.Reference:

LOOKUP Function - Tableau

Table Calculations - Tableau

Tableau Certified Data Analyst Study Guide


by Mignon at May 31, 2026, 04:09 PM

Limited Time Offer

25%

Off

Get Premium Analytics-DA-201 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Lorita
3 days ago
C seems off. It doesn’t account for the previous year’s sales properly.
upvoted 0 times
...
Tish
8 days ago
Definitely B! It calculates the difference relative to last year correctly.
upvoted 0 times
...
Glory
13 days ago
I’m leaning towards A. It’s straightforward but might miss the percent aspect.
upvoted 0 times
...
Lawana
18 days ago
I agree, B makes sense. It shows the percent difference clearly.
upvoted 0 times
...
Novella
23 days ago
This question is tricky! I think B is the right choice.
upvoted 0 times
...
Hyun
29 days ago
Not sure about B, feels like it could be wrong.
upvoted 0 times
...
Colene
1 month ago
Wait, why is D even an option? Seems weird to use ZN.
upvoted 0 times
...
Luther
1 month ago
C is totally off, that’s not how you calculate percent change.
upvoted 0 times
...
Penney
1 month ago
I think A could work too, but not as clear.
upvoted 0 times
...
Truman
2 months ago
Definitely B, it makes the most sense for percent difference.
upvoted 0 times
...
Krystina
2 months ago
I’m leaning towards option A, but I’m not entirely confident. I need to double-check how the LOOKUP function works in this context.
upvoted 0 times
...
Linn
2 months ago
I feel like I might confuse the LOOKUP function with something else. Wasn't there a similar question about year-over-year comparisons?
upvoted 0 times
...
Luisa
2 months ago
I think option B looks familiar; it seems to be the standard formula for calculating percent change.
upvoted 0 times
...
Kimbery
2 months ago
I remember practicing percent difference calculations, but I'm not sure if it's just the subtraction or if we need to divide by the previous year's sales.
upvoted 0 times
...

Save Cancel