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:
Was this helpful?
Reader Interactions