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

Actual exam question for Salesforce's Analytics-DA-201 exam

Question #: 16
Topic #: 1

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) )

Show Suggested 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:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!