cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nithinar New Member
New Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Returning 'TRUE' or 'FALSE'

@nithinar  Please try this as a new column

 

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

image.png



Did I answer your question? Like and Mark my post as a solution !

Proud to be a Datanaut !





1 REPLY 1
Super User
Super User

Re: Returning 'TRUE' or 'FALSE'

@nithinar  Please try this as a new column

 

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

image.png



Did I answer your question? Like and Mark my post as a solution !

Proud to be a Datanaut !