Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Detect round dollar amounts for fraud testing

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.  

Need Help

1 Reply

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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.