DAY DAX Function
The DAY function returns the day of the month, a number from 1 to 31.
DAX Syntax DAY(date)
The parameter data is a date in datetime format, or a text representation of a date.
Example: Create a Calculated Column.
DAX
Day column = DAY('Sheet1'[Date of Birth])
