Fabric Plan Community Logo
Sign in

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.

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
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.