Dax Function: MINUTE
Category: Date and Time Functions
The MINUTE function in Power BI is a DAX (Data Analysis Expressions) function designed to extract the minute component from a datetime or time value.
Purpose
To isolate the minute portion of a datetime value, ranging from 0 to 59.
Type of Calculations
Time-based analysis and segmentation.
Practical Use Cases
- Breaking down timestamps for granular analysis.
- Grouping data by minute intervals.
- Calculating durations or performance metrics.
MINUTE(<datetime>)
| Parameter | Type | Description |
|---|---|---|
datetime | Datetime | A valid datetime or time value from which the minute component will be extracted. |
How Does MINUTE Dax Function Works
- The function takes a datetime or time input.
- It extracts the minute portion from the input, which can range from
0(start of the hour) to59(end of the hour). - The result is a numeric value representing the minute component.
Example: For datetime = 2025-02-10 15:45:00, the result is 45.
What Does It Return?
- Type: Integer.
- Meaning: Returns the minute (0–59) extracted from the provided datetime or time value.
When Should We Use It?
- When you need to analyze data at the minute level.
- To identify trends or patterns within specific minute intervals.
- For calculating elapsed minutes between two timestamps.
Examples
Basic Usage
Extract the current minute from the system time:
MINUTE(NOW())
Output: If the current time is 2025-02-10 14:30:45, the result is 30.
Column Usage:
Add a calculated column to extract the minute from a datetime column:
OrderMinute = MINUTE(Table[OrderDate])
For OrderDate = 2023-07-21 09:15:00, the result is 15.
Advanced Usage
Combine with other DAX functions to calculate total orders placed within a specific minute of any hour:
OrdersAt15Minutes = COUNTROWS(
FILTER(Table, MINUTE(Table[OrderDate]) = 15)
)
This formula counts all rows where the order was placed exactly at the 15th minute.
Tips and Tricks
- Combine MINUTE with HOUR and SECOND for detailed time analysis.
- Use in conjunction with time difference calculations to measure elapsed time accurately.
- Preprocess datetime data in Power Query to enhance performance for large datasets.
Potential Pitfalls
- Ensure the
datetimeinput is valid and not null to avoid errors. - If working with time zones, validate that the datetime values are in the desired zone for accurate results.
Performance Impact of MINUTE DAX Function:
- Efficient for small and medium datasets. For large datasets, consider precomputing minute values in Power Query to reduce processing time.
- Avoid using the function in calculated columns for very large datasets unless necessary.
Related Functions You Might Need
- HOUR: Extracts the hour component from a datetime value.
- SECOND: Extracts the second component from a datetime value.
- TIME: Constructs a time value from individual hour, minute, and second components.
- NOW: Returns the current datetime.
Want to Learn More?
For more information, check out the official Microsoft documentation for MINUTE. You can also experiment with this function in your Power BI reports to explore its capabilities.
Unlock the full capabilities of Power BI and elevate your data insights with our specialized consulting services. Whether you need guidance on advanced DAX functions like those highlighted here, support in designing interactive dashboards, or expertise in optimizing data models for enhanced performance, our experienced Power BI consultants are equipped to deliver customized solutions for your business. Explore our Power BI Consulting Services page to discover how we can help your organization make smarter, data-driven decisions.
The MINUTE function extracts the minute component (0–59) from a datetime or time value.
Yes, the function can handle time-only inputs and will extract the minute portion.
If the input is null, the function returns an error. Use ISBLANK or IFERROR to manage null values.
Yes, you can group data by minute values using calculated columns or measures.
While MINUTE extracts the minute component, SECOND extracts the second component from a datetime or time value.
Established in 2020, Lets Viz Technologies provides a full range of high-quality data analysis and data visualization services. We are also an authorized Zoho Partner.
Sitelinks
