I am trying to convert the HH:mm value to decimal

[ajay_gupta_ga]

I am trying to convert one of the mysql table value which is in HH:MM to decimal , can anyone can help with DAX way..becuase i tried to convert the data type of this column from text to time but it was not gets convert.

[croberts21]

Is TIMEVALUE() what you want? https://learn.microsoft.com/en-us/dax/timevalue-function-dax 

Remark: "

• Time values are a portion of a date value and represented by a decimal number. For example, 12:00 PM is represented as 0.5 because it is half of a day."

DAX function reference is here. It's very handy. https://learn.microsoft.com/en-us/dax/dax-function-reference