Have you come across Value.Is ? You can you use to replicate the Excel function IF ( ISNUMBER
Power Query IF ISNUMBER is a function used in Power Query (a Microsoft Excel add-in) that checks if a value is a number. It returns a TRUE or FALSE boolean value depending on the result of the check. This function can be used to filter out non-numeric values from a dataset or to detect numerical values in a column and perform specific actions based on the result. The syntax for Power Query IF ISNUMBER is IF ISNUMBER(value) where value is any value that needs to be checked if it is a number.
Sep 27, 2020 — I want to add an additional column that states which one is number or text. In Excel, we have ISNUMBER() or ISTEXT(). Do we have any alternative in Power Query?
Aug 3, 2016 — The following is a query that creates two new columns showing if each row is a text or number type. The first column checks the data type.
Aug 4, 2022 — Indicates if the value is NaN (Not a number). Returns true if number is equivalent to Number.IsNaN, false otherwise.