1. Home
  2. Discussions
  3. Microsoft
  4. Microsoft Certified: Power BI Data Analyst Associate
  5. PL-300 Discussions
  6. PL-300 Exam Topic 7 Question 61 Discussion

Microsoft Power BI Data Analyst PL-300 Question # 61 Topic 7 Discussion

 Microsoft Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Microsoft Power BI Data Analyst PL-300 Question # 61 Topic 7 Discussion

PL-300 Exam Topic 7 Question 61 Discussion:
Question #: 61
Topic #: 7

You have a sales system that contains the tables shown in the following table.

PL-300 Question 61

The Date table is marked as a date table.

DatelD is the date data type. You need to create an annual sales growth percentage measure.

Which DAX expression should you use?
A.

SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])

B.

(SUM(‘Sales’[sales_amount]) - CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID])))/ CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

C.

CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID]))

D.

CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

Get Premium PL-300 Questions
Actual exam question for Microsoft PL-300 exam by Jett91550 at Aug 3, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next