HOTSPOT
-
You 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 snapshot
You 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.
aloysiusjw
Highly Voted 1 year, 3 months agoRicoPallazzo7
Highly Voted 1 year, 4 months agoSylUK
1 month, 2 weeks agoas198184
6 months, 3 weeks agoMo2011
9 months, 3 weeks agoAlscoran
1 year, 3 months agosarraEB
1 year, 1 month ago5bf040d
Most Recent 3 days, 6 hours agofreudn
4 months ago8b7b763
5 months, 1 week ago0e18c76
10 months, 1 week agoAbhi_1526
1 year agoyuri_rusanov
1 year, 3 months agoDmytro_UA
1 year, 2 months agoHelena1
1 year, 3 months agoAlscoran
1 year, 3 months agoRyan_042
1 year, 4 months agoaloysiusjw
1 year, 3 months agoZillowGosia
1 year, 4 months agosrujji
1 year, 5 months agotranquanghuy2111
1 year, 5 months agotranquanghuy2111
1 year, 5 months ago