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)
)
  • kristel_tulio's avatar
    kristel_tulio
    Icon for Helper III rankHelper III
    3 years ago

    Hi FreemanZ ,

     

    I just have a bit of concern can I make it an integer and show the total? And I would like to filter it using my date table. There's an indirect relationship between my Date table and that Job table. Thanks for helping out!

    Apparently the date table is not working when I change the year.