Notifications
Clear all
Power Query
4
Posts
2
Users
0
Reactions
147
Views
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
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
Topic starter
Thanks a lot for this!
Posted : 12/06/2020 9:17 pm
You're welcome.
Phil
Posted : 12/06/2020 9:44 pm
