DRAG DROP (Drag and Drop is not supported) You are creating a Power BI model and report.You have a single table in a data model named Product. Product contains the following fields:-ID-Name-Color-Category-Total SalesYou need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.Select and Place:
Answer(s): A
Box 1: TOPN TOPN returns the top N rows of the specified table.Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]ג€¦])Box 2: DESC Descending order to get the highest values first.
https://docs.microsoft.com/en-us/dax/topn-function-dax
You are creating a sales report in Power BI for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:The report will facilitate the following analysis:-The count of orders and the sum of total sales by Order Date-The count of customers who placed an order-The average quantity per orderYou need to reduce data refresh times and report query times.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
Answer(s): C,D
You are creating a Power BI model that contains a table named Store. Store contains the following fields.You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City.What should you do to ensure that the locations are mapped properly?
Answer(s): C
You are building a data model for a Power BI report.You have data formatted as shown in the following table.You need to create a clustered bar chart as shown in the following exhibit.What should you do?
DRAG DROP (Drag and Drop is not supported) You need create a date table in Power BI that must contain 10 full calendar years, including the current year.How should you complete the DAX expression? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Select and Place:
Box 1: YEAR Get the current year.Box 2: TODAY TODAY returns the current date.Box 3: CALENDAR CALENDAR returns a table with a single column named ג€Dateג€ containing a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.The following formula returns a table with dates between January 1st, 2005 and December 31st, 2015.CALENDAR (DATE ( 2005, 1, 1 ),DATE ( 2015, 12, 31 )
https://dax.guide/calendar/
Post your Comments and Discuss Microsoft PL-300 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the PL-300 content, but please register or login to continue.