Forum Discussion

rosemilo's avatar
rosemilo
Frequent Visitor
4 years ago
Solved

Extracting String Using LEFT and SEARCH function

Hello,   I'm trying to extract the number before the colon (see example below) using DAX.    Here are the steps I did: 1. To return the specified number of characters I want (it worked)  ...
Help with DAX
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi rosemilo 

    please try

     

    c_Request Target Time =
IF (
    MyRequest_Consolidated[c_Search Request Target Time] > 0,
    LEFT (
        'MyRequest_Consolidated'[Request Target Time],
        MyRequest_Consolidated[c_Search Request Target Time]
    )
)

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi rosemilo 

please try

 

c_Request Target Time =
IF (
    MyRequest_Consolidated[c_Search Request Target Time] > 0,
    LEFT (
        'MyRequest_Consolidated'[Request Target Time],
        MyRequest_Consolidated[c_Search Request Target Time]
    )
)

 

  • rosemilo's avatar
    rosemilo
    Frequent Visitor
    4 years ago

    Thank you! It worked! ğŸ˜Š