Detect round dollar amounts for fraud testing

[asundstrom]

I'm trying to create a way to detect round dollar amounts (i.e., $48.00, $47.00, etc.) from a column with various dollar amounts. I have not able to find a way unless I do a conditional column and input each individual dollar amount (which would be tedious). Any help is greatly appreciated.  

[edhans]

Two ways:

• In Power Query, use the following formula

  • = if [Dollars] * 100 = Number.Round([Dollars],0) * 100 then true else false

• In DAX in a calculated column, use this

  • DAX Fraud = 
    IF(Table1[Dollars] * 100 = ROUND(Table1[Dollars],0) * 100,
        TRUE(),
        FALSE()
        )

they both return TRUE if the dollars are even with no cents. You can change the conditions to do something besides report TRUE/FALSE.