Forum Discussion
User input in desktop
Thansk Lydia, the data will be laid out like the table below, however the Include/Exclude table needs to be manually adjusted. The check is calculated on whether or not Var% is less than 50% or greater than 200%. We sometimes want to include and sometimes exclude these variances as they may just be system errors which we do not want to include. Based on the input from the include or exclude, the NewStd column will pull either the ActualHours (if yes) or StandardHours (if no). We will then average the NewStd column by job to get our new standard hours.
Main question being, is it possible in powerbi to have a parameter or other form of user input that can set a variable for a row?
Thanks
Main question being, is it possible in powerbi to have a parameter or other form of user input that can set a variable for a row?
If you mean create Var% column dynamically based on user input, you can create what if paramater in Power BI Desktop, then create a measure named Var%.
Var% = Parameter[Parameter Value]*MAX(Table1[Var])
Then you can crate the following measures.
Include/Exclude = IF([Var%]>2, "No", IF([Var%]<0.5, "Yes",BLANK()))
NewStd = IF([Include/Exclude]="Yes" ||ISBLANK([Include/Exclude]),MAX(Table1[ActualHours]),MAX(Table1[StandardHours]))
Regards,
Lydia
Hi Lydia,
The user needs to decide whether or not to include or exclude, it is not based on a formula,
Thanks
aucklanduser,
Please elaborate that what variable the users would input, and what result would you like to get based the input based on above sample data.
Regards,
LydiaHi Lydia,
The user will input either include or exclude (1 or 0) to include or exclude the row from the calculation based on the cost accountants judgement