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.
Exhibit:
You need to create a report that meets the requirements:
• Visualizes the Sales value over a period of years and months
• Adds a Slicer for the month
• Adds a Slicer for the year
Which three actions Should you perform in sequence?
You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.
From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium
capacity.
You discover that the dataset refresh fails after the refresh runs out of resources.
What is a possible cause of the issue?
You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power Bi dataset
You need to ensure that the dataset can be refreshed in powefbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.