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.
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...
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?
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.
>>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:
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.
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!