This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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.
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.
Was this page helpful?