The Power BI DAY is a DAX Date and Time function used to return the day of the month, i.e., a number from 1 to 31 from the given Date. This article explains the POWER BI DAX DAY function that accepts the date value and returns Gregorian values (integer) from 1 to 31 and the syntax is shown below:
DAY(<date>)
The DAX DAY function takes the date value from the given datetime or text representation of the date as an argument and extracts the day of the month from it.
- The argument can be a date, datetime, or the expression that returns or is implicitly convertible to the datetime or date.
- When the date argument is the text representation of the date or datetime, the DAY function uses the current local date and time settings to understand a text value.
Power BI DAX DAY function Example
To demonstrate the DAX DAY() function, we use the Order Date column from the SuperStore Orders table. To extract day of the month for each date row, we need a new column. So, go to the Modeling Tab, click the New Column button, and rename it as Day to obtain the Day of the Month value from the Order date.
Next, please add the new Day column to the table report. Please refer to the DateTime and the function article for the remaining Power BI methods. For more Charts >> Click Here.
Day = DAY(Orders[Order Date])
You can try the below expression and it returns the same result.
Days = Orders[Order Date].[Day]
Let me create three line charts to show the day of the day-wise sales, orders, and profit. Next, we created a Stacked Column Chart with X-Axis Day, Y-Axis Profit, and Legend Sub-Category. You can click any report to see or highlight the day-of-the-month results in a particular year or Subcategory.
