Forum Discussion
User input in desktop
Hi 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
aucklanduser,
If the Include/Exclude column is a existing field or a calculated column in your table, you can create a slicer using this field for user to choose.
Otherwise, you can create what if parameter(1 or 0) as my previous reply. If you still have questions, please post expected result based on the above sample table, and elaborate more about your desired result 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 Lydia,
Think we are going round in circles. The include/exclude column is not an existing field its a theoretical user entered field. The end user needs to determine whether or not each row will be included. Not based on formula. This is a manual input by the end user. No formula can decide whether or not each row is included or excluded. I dont think this is possible, I was just asking if anyone knows of a workaround as excel processing times are rolling into the hours.
No expected result can be generated as it will depend on the users judgement of each row and whether or not said row should be included in the new calculation or excluded.
Many thanks,
Paul