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

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?

A(SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))

B(SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )

C(SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))

D(ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )

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

Get Premium Analytics-DA-201 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

15 comments · newest first

Geraldo 1 month ago

I feel B is the best option too. It’s all about that relative change!

Lorita 2 months ago

C seems off. It doesn’t account for the previous year’s sales properly.

Tish 2 months ago

Definitely B! It calculates the difference relative to last year correctly.

Glory 2 months ago

I’m leaning towards A. It’s straightforward but might miss the percent aspect.

Lawana 2 months ago

I agree, B makes sense. It shows the percent difference clearly.

Novella 2 months ago

This question is tricky! I think B is the right choice.

Hyun 2 months ago

Not sure about B, feels like it could be wrong.

Colene 3 months ago

Wait, why is D even an option? Seems weird to use ZN.

Luther 3 months ago

C is totally off, that’s not how you calculate percent change.

Penney 3 months ago

I think A could work too, but not as clear.

Truman 3 months ago

Definitely B, it makes the most sense for percent difference.

Krystina 3 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.

Linn 4 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?

Luisa 4 months ago

I think option B looks familiar; it seems to be the standard formula for calculating percent change.

Kimbery 4 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.

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