Forum Discussion

amaniramahi's avatar
amaniramahi
Icon for Helper V rankHelper 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 in...
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

TomMartens's avatar
TomMartens
Icon for Super User rankSuper 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
    Icon for Helper V rankHelper 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.