Check your knowledge

Completed

Answer the following questions to see what you've learned.

1.

In the context of semantic model calculations, which statement best describes time intelligence?

Snapshot balance reporting

Filter context modifications involving a date table

Complex calculations involving time

Calculations involving hours, minutes, or seconds

2.

You're developing a semantic model in Power BI Desktop. You've just added a date table by using the CALENDARAUTO function. You've extended it with calculated columns, and you've related it to other model tables. What else should you do to ensure that DAX time intelligence calculations work correctly?

Add time intelligence measures to the date table.

Mark as a Date table.

Add a fiscal hierarchy.

Add a date column.

3.

You have a table that stores account balance snapshots for each date, excluding weekends. You need to ensure that your measure formula only filters by a single date. Also, if no record is on the last date of a time period, it should use the latest account balance. Which DAX time intelligence function should you use?

FIRST

FIRSTNONBLANK

LAST

LASTNONBLANK

You must answer all questions before checking your work.