Power BI add manual input data in a table visual

[dgdgdg122db]

Hi there,

I want to achieve a similar result as in Excel, which I can input data in a table and calculate the result accordingly.

As the screenshot below, I have my data from the data model in column B, and I want to add a few more columns that I can also adjust the percentage easily.

Can someone please advice?

Thanks

[v-frfei-msft · Accepted solution]

Hi @dgdgdg122db ,

We can achieve that by merging tables in power query. Please check the following steps as below.

1. Enter the input 1 and input 2 and insert index column for all the tables.

2.After that, merge the table as below.

3. Based on the merged table, add the custom columns like that.

Then we can get the excepted result as we want.

For more details, please check the pbix as attached.

[dqG9kYbAmF7tfNx]

Probably, you can use What-if Parameter (from Modeling - What if), and create 5 parameters; set the data type, the min and max values you may expect it. Then you can use them as slicers in the dashboard.

I know this is not professional but at least it may work.