Forum Discussion
User input in desktop
Im trying to design a better process for our cost accountant, he is currently spending hours each month waiting for bulky spreadsheets to calculate, our 20 million odd line dataset loads almost instantly in powerbi. What he needs however is the ability to exclude specific job assemblies from a calculation. As this is "art not science", it cannot be calculated, reasons need to be taken into account before a decision is made whether to include or exclude outliers. Preferably dont want to filter the operations individually as there will be many thousands of operations a month to look through. Ideal output would be an "include" column that has jobs over 200% of standard or under 50% of standard, which can be set by the user as 1 or 0, then filter on this.
Sorry if this is very vague, more about the concept of having a user editable element, just trying to cut down some excel processing time.
12 Replies
aucklanduser if you can provide some sample data and business rule around what to exclude/include , it wil help to provide the solution. Even What-If parameter can be use in this scenario if % are not fixed for include/exclude.
Hey Parry,
Havent developed the dataset yet as I will just leave it if its not possible but it will look like;
Date Job# Assy# ActualHours StandardHours VarToStd Var% Include/Exclude?
For each jobs assembly, we are assessing the variance to our current standard (e.g the build operation for widget A normally takes 1 hour but for job 1 it took 3 hours). He currently pulls anything less than 50% of the current standard or over 200% of the current standard (100% positive / minus) and then looks at the reasons for the variances and will either include or exclude these in the calculation of the new standard. The user needs the ability to flag particular rows as either include or exclude in the new average hours (standard) calculation for each assembly.
How would a what if parameter be used? Many thanks for your help
aucklanduser,
Please share sample data of your table and post expected result based on sample data following the guide in the blog below.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lydia
Hi aucklanduser , were you able to find a solution? I am looking to solve a very similar problem.
Anonymous , yes and no, we haven't implemented a solution however I think its possible by embedding a PowerApp. You will however need an Enterprise license for PowerBI if you want the data to refresh after you have made changes (annoyingly, the only real use for it) or you have to wait for your scheduled refresh
