Forum Discussion

Alta88's avatar
Alta88
Icon for Helper IV rankHelper IV
4 years ago

Creating Flags for Data Discrepancies

I'm building a table that pulls data from one of our systems for auditing purposes to cut down on manual review through actual account screens. The idea is to create flags for multiple fields so ever...
Need Help
Alta88's avatar
Alta88
Icon for Helper IV rankHelper IV
4 years ago

How would I put the following into DAX syntax?

 

If Credit Score is less than 625, then flag as error.

 

If credit score is 625 or greater, then flex pay should equal $2K, otherwise, flag as error.

 

If Credit Score is 700 or greater, then flex pay should equal $10K, otherwise, flag as error