Tag Archive | ADD COLUMNS

Lifetime Calendar

The Lifetime calendar looks at Last 30 Days, Last 60 Days, Last 90 Days, Last 180 Days and the Lifetime Calendar.

To enable this, we create a new table in DAX.

We use the Calculatetable function the Calendar Date and use the DatesBetween dates to calculate the period of Last 30 Days, Last 60 Days, Last 90 Days and Lifetime.

We use ADDCOLUMNS to define the Time Periods.

The result table is as below: