MONTH DAX Function in Power BI
The MONTH DAX function in Power BI returns the month as a number from 1 (January) to 12 (December) in Power BI. It can be used to create a calculated column to sort column for the Month column.
DAX Syntax MONTH(date)
The parameter date is a date in datetime format, or a text representation of a date.
Example: Create a Calculated Column. The following expression returns the month from the date in the Date of Birth column of the Sheet1 table.
DAX
Month Column = MONTH('Sheet1'[Date of Birth])
The output of the above dax code is shown below:
Example: Let’s get the month number from the today’s date. For example, the today’ date is 12 Jan 2025.
DAX
Month component = MONTH(TODAY())
The output of the above measure, can be shown in the card visual, as shown in the image below:
