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
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    nithinar  Please try this as a new column

     

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

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

nithinar  Please try this as a new column

 

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