Power Fx function
Year / Month / Day — Power Fx function reference
Pull a part from a date.
Syntax
powerfx
Year( Date ) / Month( Date ) / Day( Date )
Examples
powerfx
Month(Today())
→ A number
powerfx
Filter(Orders, Year(Created) = Year(Today()) && Month(Created) = Month(Today()))
powerfx
Day(DateAdd(Today(), 1, TimeUnit.Days))
Common mistakes & gotchas
- These extract integer parts only — there is no single built-in "start of month" or "end of month" function; build it from Date(Year(d), Month(d), 1) style patterns.
- Filtering by separate Year()/Month() calls is typically non-delegable on SharePoint/Dataverse — prefer a direct date-range comparison for delegable filtering on large tables.
Related Power Fx functions
From Date & time