Is there an ISNUMBER() or ISTEXT() equivalent in Power Query
While data cleaning using the power query, I came across a situation where a column contains both text and numerical values. 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? Below is an Excel screenshot, an alternative of which want in Power Query.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!