Microsoft Power BI Data Analyst PL-300 Question # 18 Topic 2 Discussion

Microsoft Power BI Data Analyst PL-300 Question # 18 Topic 2 Discussion

PL-300 Exam Topic 2 Question 18 Discussion:
Question #: 18
Topic #: 2

You are building a Power Bl report that uses data from an Azure SQL database named erp1.

You Import the following tables.

PL-300 Question 18

You need to perform the following analyses:

• Orders sold over time that include a measure of the total order value

• Orders by attributes of products sold

The solution must minimize update times when interacting with visuals in the report. What should you do first?


A.

From Power Query, merge the Orders query and the Order Line Hems query.


B.

Calculate the count of orders per product by using a DAX function.


C.

Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.


D.

From Power Query, merge the Order Line Items query and the Products query.


Get Premium PL-300 Questions

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.