DAX Function Guide

Unlike Microsoft Excel, which stores dates and times in a serial numeric format, DAX uses dates and times with a datetime data type. The datetime value for the MINUTE function can be given by referencing a column that stores dates and times, using a date / time function, or using an expression that returns a date and time.

When the datetime statement is a text representation of the date and time, the method uses the client computer’s locale and date / time settings to recognize the text meaning to make the conversion. Some locales use the colon (:) to translate correctly as the time separator and any input text use colons as time separators. To understand your results, check your locale settings.