Date table creation in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a date table using CALENDAR function.

Power BI

DateTable = CALENDAR([1], "2024-12-31")

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

A"01-01-2024"

BTODAY()

C"2024-01-01"

DNOW()

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect date format like mm-dd-yyyy

Using functions like TODAY() inside CALENDAR without conversion

The CALENDAR function requires start and end dates as date values, not text strings. "2024-01-01" should be converted to a date using DATE function or provided as a date value.

2fill in blank

medium

Complete the code to add a Year column to the date table.

Power BI

Year = YEAR([1][Date])

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

ACalendar

BDateTable

CDates

DDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong table name

Using the column name instead of table name

The YEAR function extracts the year from the Date column in the DateTable.

3fill in blank

hard

Fix the error in the code to create a date table with continuous dates.

Power BI

DateTable = CALENDAR(DATE(2024,1,1), [1](2024,12,31))

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

ADATETIME

BTODAY

CNOW

DDATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using NOW or TODAY which return datetime, not date

Using DATETIME which is not a DAX function

The DATE function is used to create a date value from year, month, and day. Using DATE(2024,12,31) is correct.

4fill in blank

hard

Fill both blanks to add Month and Quarter columns to the date table.

Power BI

Month = FORMAT([1][Date], [2])

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

ADateTable

B"MMMM"

C"Q"

DCalendar

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong table name

Using incorrect format string like "Q" for month

FORMAT function formats the Date column from DateTable to show full month name using "MMMM".

5fill in blank

hard

Fill all three blanks to create a calculated column for Fiscal Year starting in July.

Power BI

FiscalYear = IF(MONTH([1][Date]) >= [2], YEAR([3][Date]) + 1, YEAR([3][Date]))

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

ADateTable

B7

CCalendar

D6

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong month number

Using different table names inconsistently

This formula checks if the month is July (7) or later, then adds 1 to the year for fiscal year calculation.