New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

ISNUMBER, ISTEXT, ISDATE equivalent in Power Query or M

If you need to identify which values in a column are number, text or date, in today’s video, I am going to show you 2 ways to do it.

Table of contents:

00:00 Intro
00:22 Problem description
00:50 Solution1 with Value.Type
01:34 Avoid issues
02:22 Solution2 with Value.Is

Watch the tutorial:

ISNUMBER, ISTEXT, ISDATE equivalent in Power Query or M
Was this helpful?
Previous Split text by capital letters and non/digits in Power Query
Next Replace multiple values in Power Query in one step

Reader Interactions

Let us know your thoughts...

Table of Contents