Forum Discussion

amaniramahi's avatar
amaniramahi
Helper V
7 years ago
Solved

Table with formula and manual input

I am very new to power BI so excuse me if my question is naive.

I would like to know, If I can create new table, the first column is a distinct value from another column in a different query, and input the data in the second column manually.

Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    unfortunately this is not possible.

     

    You can start with manual input, and add "calculated columns" in a 2nd step, this means if it's possible to "deduct" the "unique" values for the 2nd column by some kind of business logic, then you can achieve what you are looking for.

    But it's not possible to mix a calculated table "the unique values from table one" with manual input.

     

    Hopefully this provides you with some ideas.

     

    Regards,

    Tom

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    Hey,

     

    unfortunately this is not possible.

     

    You can start with manual input, and add "calculated columns" in a 2nd step, this means if it's possible to "deduct" the "unique" values for the 2nd column by some kind of business logic, then you can achieve what you are looking for.

    But it's not possible to mix a calculated table "the unique values from table one" with manual input.

     

    Hopefully this provides you with some ideas.

     

    Regards,

    Tom

    • amaniramahi's avatar
      amaniramahi
      Helper V
      7 years ago

      Thank you TomMartens ..

      Actually I tried the other way as you said to enter data manually then put in the second column the distinct values, it did not work and gave an error.

       

      Thanks anyway.