Forum Discussion

michellepace's avatar
michellepace
Resolver III
5 years ago
Solved

Test for whole number?

Hello, Is there a better way to test for a whole number than the below? I can't help but think there simply HAS to be a built-in function?   = if Number.Mod([Task ID], 1) = 0 then true else false
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi michellepace ,

    You can create a custom column like this:

    = Table.AddColumn(#"Changed Type", "Custom", each if [Task ID] = Int64.From([Task ID]) then true else false)

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi michellepace ,

You can create a custom column like this:

= Table.AddColumn(#"Changed Type", "Custom", each if [Task ID] = Int64.From([Task ID]) then true else false)

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.