Mark as date table in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to mark the 'Date' table as a date table using the correct column.

Power BI

MARKASDATETABLE('Date', '[1]')

Drag options to blanks, or click blank then click option'

ADate

BDateKey

CYear

DMonth

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a column that only contains year or month values.

Using a column with numeric keys instead of actual dates.

The 'Date' column is typically used to mark a table as a date table in Power BI.

2fill in blank

medium

Complete the DAX expression to mark 'Calendar' as a date table using the correct date column.

Power BI

MARKASDATETABLE('Calendar', '[1]')

Drag options to blanks, or click blank then click option'

ACalendarDate

BDay

CDate

DCalendarKey

Attempts:

3 left

💡 Hint

Common Mistakes

Using a numeric key column instead of a date column.

Selecting a column that only contains day or month numbers.

The 'Date' column is the standard column to mark a date table in Power BI.

3fill in blank

hard

Fix the error in the DAX code to correctly mark 'SalesDate' as a date table with the right column.

Power BI

MARKASDATETABLE('SalesDate', '[1]')

Drag options to blanks, or click blank then click option'

ADateKey

BDate

COrderDate

DSalesDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using a column from another table.

Using a numeric key column instead of a date column.

The column used to mark the date table must be the actual date column in the 'SalesDate' table, which is 'SalesDate'.

4fill in blank

hard

Fill both blanks to mark 'DateTable' as a date table using the correct function and column.

Power BI

DEFINE
  VAR DateTbl = [1](DATE(2020,1,1), DATE(2020,12,31))
EVALUATE
  MARKASDATETABLE(DateTbl, '[2]')

Drag options to blanks, or click blank then click option'

ACALENDAR

BDate

CCALENDARAUTO

DDateKey

Attempts:

3 left

💡 Hint

Common Mistakes

Using CALENDARAUTO with explicit dates.

Marking with a non-date column.

Use CALENDAR to create a date table and mark it with the 'Date' column.

5fill in blank

hard

Fill all three blanks to create a date table and mark it correctly with the right function and column.

Power BI

VAR DateRange = [1](DATE(2021,1,1), DATE(2021,12,31))
RETURN
  [2](DateRange, '[3]')

Drag options to blanks, or click blank then click option'

ACALENDAR

BMARKASDATETABLE

CDate

DCALENDARAUTO

Attempts:

3 left

💡 Hint

Common Mistakes

Using CALENDARAUTO instead of CALENDAR with explicit dates.

Marking with a column that is not a date.

First create a date range with CALENDAR, then mark it as a date table using MARKASDATETABLE with the 'Date' column.