Solved: Returning 'TRUE' or 'FALSE'

nithinar · ‎02-20-2019

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

PattemManohar · ‎02-20-2019

@nithinar Please try this as a new column

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

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

Proud to be a PBI Community Champion

PattemManohar · ‎02-20-2019

@nithinar Please try this as a new column

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

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

Proud to be a PBI Community Champion

Returning 'TRUE' or 'FALSE'