Forum Discussion
Solved
Testing if integer in PBI (M not DAX)
Hello experts, Is it possible for M to test whether my number values are integers? Column1 0.2212 0.45554321 0.6 0.84321896 1 1.2 1.000004 1.76219026 1.8212154 ...
Hi,
In the Query Editor, use this M code
=if Number.Mod([Column1],1)=0 then "T" else "F"
Hope this helps.
Zubair_Muhammad great thanks. I can loose two steps with your solution. Do you know if there is any built-in M syntax that tests for an integer?