SOMONTH

The SOMONTH function returns the start date of the month for a given date. References and measures are also accepted as arguments. This function is commonly used to identify monthly reporting periods and perform month-based calculations.

Syntax

SOMONTH(date)

Arguments

  • date: The input date.

Return value

Returns the start date of the month.

Example

SOMONTH("05/29/2026")

Returns 5/1/2026, which is the start date of the month containing 05/29/2026.

Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.