Forum Discussion
Create New Table
"type" data where? Powerbi is not a place where you enter data, it's not excel.
You should prepare data in advance.
It's better if you explain your requirement.
Define "manually filled"?
You can use a combination of ADDCOLUMNS, SELECTCOLUMNS and DISTINCT
something like
ADDCOLUMNS(SELECTCOLUMNS(DISTINCT(yourtable[yourcolumn])); "new column"; new values)
Anonymous thank you,
you're right on asking more details on "manually filled". I need to be able to type values in the 2nd column.
So 1 column is the result of a DAX formula, the 2nd column is where I type data. Is that possible?
"type" data where? Powerbi is not a place where you enter data, it's not excel.
You should prepare data in advance.
It's better if you explain your requirement.well, I tried to do something that, one day, will become available 😁
Meantime, I will have to either manage the situation on each SQL server (preferred as it is dynamic) or use an Excel sheet.
I don't think it will become available as PBI is an analytical solution, so you don't typically enter data in these tools. What you can do is to enter "parameters" (using the function available in PBI) which can be used for what-if scenarios.
But again: what is your requirement? If you HAVE TO *enter* data make reports, you're not "thinking it" correctly.