Table with formula and manual input

[amaniramahi]

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.

[TomMartens · Accepted solution]

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]

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.