cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alta88
Helper III
Helper III

Using Power BI for Quality Control Audits

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. 

6 REPLIES 6
Alta88
Helper III
Helper III

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...

Ok. Where are you stuck?

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?

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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
Super User
Super User

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

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors