Forum Discussion
DAX CODE FOr SLIT
I WANT TO GET RESULT 1 FROM 3:01,ANYONE CAN SUGGEST THE CODE?
shafiz_p
Super User
Super UserHi rabeeh
If you have just string value, you can use the below code:
Result =
VAR SpStr = SUBSTITUTE("3:01", ":","|")
RETURN
RIGHT(SpStr, 1)
If you are working with a column, the adjusted code would be
Hope this helps!!
If this solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz
If you are working with a column, the adjusted code would be
Result =
VAR SpStr = SUBSTITUTE(Table[ColumnName], ":","|")
RETURN
RIGHT(SpStr, 1)
Hope this helps!!
If this solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz