Forum Discussion

michellepace's avatar
michellepace
Icon for Resolver III rankResolver 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.

3 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    michellepace 

     

    The logic is the same but you can get rid of the IF:

    Number.Mod([TASKID],1)=0

    ________________________

    If my answer was helpful, please click Accept it as the solution to help other members find it useful

    Click on the Thumbs-Up icon if you like this reply 🙂


    Website YouTube  LinkedIn

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    You can use Value.Is:

     

    Table.AddColumn(PriorStep, "Whole Number", each Value.Is([Task ID], Int64.Type))

     

    Or if you need it as a filter, you can also use "if" syntax

    if Value.Is([Task ID], Int64.Type) then xxx else yyy

    --Nate

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity 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.