HOTSPOT You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales. You need to create a measure that calculates the total sales from the equivalent month of the previous year. How should you complete the calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area
HOTSPOT You are enhancing a Power BI model that has DAX calculations. You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year. Which DAX functions should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area
HOTSPOT You are building a financial report by using Power BI. You have a table named financials that contains a column named Date and a column named Sales. You need to create a measure that calculates the relative change in sales as compared to the previous quarter. How should you complete the measure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area
DRAG DROP 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 CertyIQ
✑ Total Sales
You 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:
DRAG DROP 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
HOTSPOT You have a Power BI report that contains a measure named Total Sales. You need to create a new measure that will return the sum of Total Sales for a year up to a selected date. 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. Hot Area
DRAG DROP You are modifying a Power BI model by using Power BI Desktop. You have a table named Sales that contains the following fields
You have a table named Transaction Size that contains the following data
You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount. How should you complete the code? 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. NOTE: Each correct selection is worth one point. Select and Place
HOTSPOT You are creating a quick measure as shown in the following exhibit
You need to create a monthly rolling average measure for Sales over time.How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point
You have the Power BI data model shown in the following exhibit
The Sales table contains records of sales by day from the last five years up until today’s date. You plan to create a measure to return the total sales of March 2021 when March 2022 is selected. Which DAX expression should you use?
Last changed2 minutes ago
