Blog Post

Power BI Community Blog
2 MIN READ

Test for a Number in Power Query M Language

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago
Use Case - The question this time is how to test in Power Query M Language whether a given value is number or not. Below are a set of values and format they are stored in and what is the expected res...
Updated 4 years ago
Version 4.0
how to
Number
Power Query
tips & tricks
Vijay_A_Verma's avatar
Most Valuable Professional
Joined August 03, 2021
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
ejbriones's avatar
ejbriones
Regular Visitor
1 year ago

This is great content. It helped me extract both the numbers and text remarks of each cell in an Excel source