Forum

Alternative to ISNU...
 
Notifications
Clear all

Alternative to ISNUMBER in Power Query

4 Posts
2 Users
0 Reactions
311 Views
(@boomie)
Posts: 6
Active Member
Topic starter
 

Hi, Please can you help me figure this out? What is the alternative to ISNUMBER in Power Query? I'm trying to write the formula in the attached file in Power Query. Thanks a lot.

 
Posted : 12/06/2020 7:13 pm
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

Hi Bunmi,

You can check the type of a value using Value.Type like so

if Value.Type(

) = type number then Text.End(Text.From(

),5) else Text.Start(

,3)

Create a custom column with this - see attached.

Regards

Phil

 
Posted : 12/06/2020 9:09 pm
(@boomie)
Posts: 6
Active Member
Topic starter
 

Thanks a lot for this!

 
Posted : 12/06/2020 9:17 pm
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

You're welcome.

Phil

 
Posted : 12/06/2020 9:44 pm
Share: