DAY DAX Function in Power BI
The DAY dax function returns the day of the month, a number from 1 to 31.
DAX Syntax DAY(date)
The parameter date is a date in datetime format, or a text representation of a date.
Example: Let’s create a Calculated column.
DAX
Day column = DAY('Sheet1'[Date of Birth])
The output of the above dax code is shown below:
