Input form

[srdtfyg]

Currently looking for a tool to make a forecast input form. Form that would be able to show exsisting column data while inputing additional values in forecast column.     

 Are there any idea how to do that? With PowerApps it didn't workout - data is quite large. Tried Inforiver editable visual matrix, but would like to use excel or other similar solution. 

PowerBI report (datasource - sqldatabase) <-> excel (forecast column + visible data from sqldatabase)

Thanks for your suggestions. 

[v-jianboli-msft]

Hi @srdtfyg 

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[srdtfyg]

 Hey, I put a preview of the table I want to make. There are two value columns - showing up existing values till this day and a blank column for input - so other users could enter the values in it.   It would look pretty much the same in excel. Thanks for your help