Forum Discussion
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
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.
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 š