Question 291

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?
  • Question 292

    You are creating a query to be used as a Country dimension in a star schema.
    A snapshot of the source data is shown in the following table.

    You need to create the dimension. The dimension must contain a list of unique countries.
    Which two actions should you perform? Each correct answer presents part of the solution.
  • Question 293

    You need to create a measure that will return the percentage of late orders.
    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.

    Question 294

    You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.

    Question 295

    You have an on-premises Power BI Report Server.
    You plan to create a report in Power BI Desktop and publish the report to the report server.
    Which data source should the report use?