What is extracting year, month, day from a date?

< 1 min read

Extracting year, month, and day means creating separate fields from a single date column.
In my project, Order Date “09-Feb-2026” was split into Year = 2026, Month = 2, Day = 9.
Year helps in annual trend analysis, Month for monthly reporting, Day for daily insights.
We also created derived fields like Quarter = INT((Month+2)/3).
Extraction was done in Power Query during transformation.
It enables easier grouping, filtering, and aggregation in visuals.
Helps build hierarchies for drill-down in dashboards.
Avoids repetitive calculations in DAX measures.
Makes time-based KPIs ready for reporting.
So it simplifies temporal analysis and enhances reporting flexibility.

Power BI Essentials