Forum Discussion

kristel_tulio's avatar
kristel_tulio
Icon for Helper III rankHelper III
3 years ago
Solved

Extracting specific text using measure

Hi!,   I would like to ask if I can use calculated measure in extracting specific values instead of using calculated column because I will just use the result in other measures so need to add colum...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi kristel_tulio 

    try like:

    Measure =
    var _number = MAX( Job[Number] )
    RETURN
    IF(
        CONTAINSSTRING(_number, "_"),
        RIGHT(_number, 3)
    )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi kristel_tulio 

try like:

Measure =
var _number = MAX( Job[Number] )
RETURN
IF(
    CONTAINSSTRING(_number, "_"),
    RIGHT(_number, 3)
)