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)