How to extract contract start and finish dates from database in Power BI

In Excel, showing contract start or finish is simple: just check the milestone activity.

In Power BI, we work with data columns so returning a single value requires a different approach.

Start Date: Use the "earliest" of the baseline early start date, then format it for clarity (e.g., 05-Jan-26).

Start Date: Choose the "latest" date in the finish column

Key Step: Cards only return one value. For dates, you must specify whether you want the earliest or the latest entry.

In this video, I explain how you can extract the Contract start and finish dates from your Power BI database.