The Power BI MINUTE function is one of the DAX Date and Time functions used to return the minute numbers from 0 to 59 from the given DateTime. This article explains the MINUTE function that accepts the datetime value and returns an integer from 0 to 59 and the syntax is shown below:
MINUTE(<datetime>)
The MINUTE function takes the time value as the argument and extracts the MINUTE part from it. The argument can be a time, a combination of date and time, direct input, or the expression that returns the datetime. If you provide the text representation of the datetime as the argument, the DAX MINUTE function uses the local computer date/time settings to read the value.
Power BI DAX MINUTE function Example
To demonstrate the DAX MINUTE() function, we use the HireDate column from the NewEmployee table. To extract Minute for each date row, we need a new column. So, go to the Modeling Tab, click the New Column button, and rename it as Minutes to obtains Minute values from the hire date.
Next, please add the new Minutes 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.
Minutes = MINUTE(NewEmployee[HireDate])
You can create a bar chart to show the Minutes-wise sales (sum of the sales by the employees hired Minutes ). To do so, use Minutes on the X-Axis and the Sales or profit on the Y-Axis. In real-time, if you replace the HireDate with OrderDate, you get the which Minute is ideal to pitch more sales.