You have a dataset that contains revenue data from the past year.
You need to use anomaly detection in Power Bl to show anomalies in the dataset.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You are creating a Power 81 model to analyze inventory.
You load data into three tables named Date Product, and Inventor/. The Inventor/ table relates to the Date and Product tables by using one-to-many relationships.
Inventor)' data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.
How should you complete the measure? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point
You have a Power Bl report that contains a clustered bar chart. The chart has an X-axis named Sales and a Y- axis named Year. The chart displays sales data for the years 2020 through 2024.
You need to create a visual calculation to show a cumulative total of sales that is equal to the sum of the current year ' s sales plus all the sales from the previous year.
Which DAX expression should you use?
In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.
Every Product has a ProductSubCategory.
Not every ProductsubCategory has a parent ProductCategory.
You need to merge the three quer ies into a single query. The solution must ensure the best performance in Power Query.
How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type 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.
You have a PBiX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database.
You need to change the connections in the PBIX file. The solution must minimize administrative effort.
What should you do?
