Forum Discussion

Alta88's avatar
Alta88
Helper 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
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Alta88 ,

 

Assume that the data from the first day is used as the baseline, and after each update of the data. Create a measure to compare the new column of data with the baseline data, and if there is a difference, mark it in red. Refer to the following test.

after refresh:

M_ = IF((MAX(Sheet1[Day1]) - MAX(Sheet1[Update]))=0,"black","red")


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Alta88's avatar
Alta88
Helper IV
3 years ago

I like that concept, but our audit process is more so about flagging errors based on user errors and specific account criteria. We build several types of accounts and each have specific criteria based on those types.