<< Prev Question Next Question >>

Question 11/21

You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Recent Comments (The most recent comments are at the top.)

rangschits - Feb 21, 2025

Yes
Yes
No

Qi - Jul 03, 2022

No - RELATED() returns a SINGLE value that is related to the current row. Won't work on many-to-many relationship.
No
No

David Webb - Jun 26, 2021

Yes - RELATED() returns a related value from another table.
No - The DAX expression will return a measure of total sales for all sales, that is 790.
No - TX will not be included as TX does not appear in CityData[State].

Brfauligfo Berlangahh - Mar 08, 2021

many of your answers a terrible wrong

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (21q)
Question 1: You have four sales regions. Each region has multiple sales ...
Question 2: You need to calculate the last day of the month in the balan...
1 commentQuestion 3: You create a dashboard by using the Microsoft Power Bl Servi...
Question 4: You need to create a calculated column to display the month ...
Question 5: You have a collection of reports for the HR department of yo...
Question 6: You need to recommend a strategy to consistently define the ...
1 commentQuestion 7: You are developing a report page. Some users will navigate t...
Question 8: You build a report to analyze customer transactions from a d...
Question 9: You build a report to help the sales team understand its per...
Question 10: You are configuring a Microsoft Power Bl data model to enabl...
4 commentQuestion 11: You are creating a Microsoft Power Bl model that has two tab...
Question 12: You have a Microsoft Power Bl dashboard. You need to ensure ...
4 commentQuestion 13: You import a large dataset to Power Query Editor. You need t...
Question 14: You need to address the data concerns before creating the da...
1 commentQuestion 15: You are creating a visual to show the ranking of product cat...
Question 16: You have a table that contains sales data and approximately ...
1 commentQuestion 17: You are creating a Microsoft Power Bl imported data model to...
1 commentQuestion 18: You are creating an analytics report that will consume data ...
1 commentQuestion 19: You have a report page that contains the visuals shown in th...
1 commentQuestion 20: Once the profit and loss dataset is created, which four acti...
2 commentQuestion 21: You are creating a column chart visualization. You configure...