PL-300 Microsoft Power BI Data Analyst Exam Actual Questions

Hotspot QuestionYou are creating a Power BI report that will show the number of current employees over time. The report will use Import storage mode for all tables.The employment data will be imported from Azure SQL Database in a monthly snapshot. The data will be stored in a table named Headcount and will contain the following:- One row per employee for each month the employee is employed- In each row, a date key that shows the first day of the month of each snapshotYou have a related date table that contains dates for the years 2020 to 2030.You need to create a semi-additive DAX measure that will return the count of employees for the last available date in a year, quarter, or month.How should you complete the measure? To answer, select the appropriate options in the answer area.