Mark as date table in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table contains daily sales data with a Date column and Sales amount.

Cell	Value
A1	Date
A2	2024-01-01
A3	2024-01-02
A4	2024-01-03
B1	Sales
B2	100
B3	150
B4	200

Formula Trace

CALENDAR(MIN('SalesData'[Date]), MAX('SalesData'[Date]))

Step 1: MIN('SalesData'[Date])

Step 2: MAX('SalesData'[Date])

Step 3: CALENDAR(DATE(2024,1,1), DATE(2024,1,3))

Cell Reference Map

   A          B
1 Date       Sales
2 2024-01-01 100
3 2024-01-02 150
4 2024-01-03 200

References: 'SalesData'[Date] column cells A2:A4

The formula uses the Date column from the SalesData table, cells A2 to A4.

Result

   A
1 Date
2 2024-01-01
3 2024-01-02
4 2024-01-03

The result is a new date table with all dates from the minimum to maximum date in the original data.

Sheet Trace Quiz - 3 Questions

What does the MIN('SalesData'[Date]) function return?

A The latest date in the Date column

B The earliest date in the Date column

C The total number of dates

D The average date value

Key Result

CALENDAR(MIN(DateColumn), MAX(DateColumn)) creates a continuous date table from min to max date.