Using Power BI for Quality Control Audits

[Alta88]

My team is in the process of advancing our auditing (QC) process and we're struggling to find an efficient solution through Power BI. The current process is as follows:

A report is downloaded listing all accounts completed the day prior. We run an Excel macro to filter down how many each account-builder did and then we manually filter their work by a certain percentage. The filtered spreadsheet then gets uploaded to a shared portal and we work off that list and manually check every account in the source system. Any errors noted are logged in a separate shared spreadsheet. 

[Alta88]

We need to group all the accounts that each account builder has worked to each of their names. We then need to sample each account builder's work by a certain percentage and then select those for review...

[lbendlin]

Ok. Where are you stuck?

[Alta88]

I'm not sure which formulas to use to get this all to work. Does this involve FILTER or MAX/MIN fucntions? Is there an IF SEARCH function available in Power BI?

[Anonymous]

Hi @Alta88,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

>>I'm not sure which formulas to use to get this all to work. Does this involve FILTER or MAX/MIN fucntions? Is there an IF SEARCH function available in Power BI?

You can take a look at the following blog about use Dax to achieve string comparison:

From SQL to DAX: String Comparison 

Regards,

Xiaoxin Sheng

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?