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
AnkitKukreja's avatar
AnkitKukreja
Icon for Super User rankSuper User
5 years ago

Hi chavanr 

I hope I got your reuirement right, please try below dax

 

Time in New2 =
     RIGHT( 'Time Split'[TIme in new] , 10)
If still it doesn't work create another column and use Trim function to remove extra spaces.
 
chavanr's avatar
chavanr
Icon for Resolver I rankResolver I
5 years ago

Hi AnkitKukreja 

I am already using the RIGHT function & also tried to use the trim function(to remove spaces) as well but not useful as it is converting the data type 'time' to 'text' & removes the seconds value for the time stamp