Forum Discussion

nithinar's avatar
nithinar
Frequent Visitor
7 years ago
Solved

Returning 'TRUE' or 'FALSE'

Hi,

 

I need help on returning a value as 'true' if the column field beings with a number. I have the value on Excel but not able to get it on Power Bi.

 

Thanks,

Nithin

Need Help

1 Reply

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    nithinar  Please try this as a new column

     

    Flag = IF(ISERROR(LEFT(Test199NumCheck[Data],1)+1),FALSE(),TRUE())