Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

MID function with a dynamic start point

Hi Im trying to run a MID where starting points depends on every row, that's why is link to column instead of having a fixed value. But for some reason, I get an error. You know how can I make it wo...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi Anonymous ,

    I'm apologize that this formula lacks a ")". Please try the formula again.

    Column =
IF (
    ISERROR ( MID ( 'Campaign (1)'[Labels on Campaign], 'Campaign (1)'[A], 10 ) ),
    BLANK (),
    MID ( 'Campaign (1)'[Labels on Campaign], 'Campaign (1)'[A], 10 )
)

    Best Regards,

    Xue

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks, Xue

 

I tried your formula but didn't work.

I've checked and column A has some blank cells.

v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi Anonymous ,

I'm apologize that this formula lacks a ")". Please try the formula again.

Column =
IF (
    ISERROR ( MID ( 'Campaign (1)'[Labels on Campaign], 'Campaign (1)'[A], 10 ) ),
    BLANK (),
    MID ( 'Campaign (1)'[Labels on Campaign], 'Campaign (1)'[A], 10 )
)

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.