Power Query IF ISNUMBER

Have you come across Value.Is ? You can you use to replicate the Excel function IF ( ISNUMBER

[dhunusarma]

I was looking for this. Simple yet brilliant solution

[lynxwomancat]

BRILLIANT! Thank you. I always type the dot then get duplicate language.

[sivaranjanisundaram]

If your bring data through Import Mode from SQL Data base.
And you want to create a calculated column.
Better to create it at the database itself or in PQE .
Also some Data Transformations better to do at SQL Data base or PQE .
( SQL data - Import Mode Only)
Which way is preferred performance wise for Import Mode data from SQL

[vamsik]

How to learn Power Query and DAX? Is there any good course on it? Please suggest.