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

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]
    )
)

Forum Discussion

Extracting String Using LEFT and SEARCH function

Related content

Extract part of text string

DAX: extracting string using delimiter

Extract Date from String

Extract part of string before specific character

Extract part of text string power query