Forum Discussion

dgdgdg122db's avatar
dgdgdg122db
Icon for Helper II rankHelper II
6 years ago
Solved

Power BI add manual input data in a table visual

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 colu...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    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's avatar
dqG9kYbAmF7tfNx
Frequent Visitor
6 years ago

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.