Table that can switch between Manul entries and System Data

[PBI_1107]

Hello All,

I have a question. Can we have a table with System generated Data along with an option or a feature where we can change the values of certain column in the table accordingly and be able to analyse the outcome with it. Let me give you an excample:
I have a table for Schedules for a list of products. These Schedules are System generated data based on the inventory and shipments history, So that there will be a balance in the Inventory. Now For certain Product I want to Enter a value for lets say a couple of months just to see if the shipments reach the target range that I have Manually entered. Or another reason could be that I want to make sure just to make sure these products have enough Inventory so in the future the products dont run out of Inventory. If there is any feature or visualization I can use to perform this task please let me know.

Thank you,
PBI_1107

[lbendlin · Accepted solution]

Your only options at the moment are What-If?  parameters or a PowerApps visual with write permission to your Direct Query data source.  Apart from that Power BI has no current functionality to allow you to modify the currently loaded dataset.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

[PBI_1107]

Hello @lbendlin, 
Thank you for your response, really appreciate it.