Forum Discussion

chavanr's avatar
chavanr
Icon for Resolver I rankResolver I
5 years ago

Split time value column in DAX

Hi there,   I have created a new calculated column with "concatenate" function  & need to split the same new column as per the "-" seperator. I need the time value which is on the right side as my...
Help required
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

chavanr , Try a new column like this in DAX

right([time in new] , len([time in new]) - search("-",[time in new],,0)+1)

chavanr's avatar
chavanr
Icon for Resolver I rankResolver I
5 years ago

Hi amitchandak 

 

Facing a issue with format now, after concatenate, the "Time In New" column is converted to text.

 

Error message"Cannot convert value '9:32:30 AM-' of type text to type number.

 

I did use the FORMAT for the "Time In New" column but is still gives in text format

Is there a workaround for this one?

 

Many thanks!!