Create New Table

[EVEAdmin]

Hi all

I would like to create a new table with 2 columns, where:

1. column one contains distinct values from a column in another table
2. column two is manually filled

Is that possible ? Then, how?

[ibarrau]

Hi, if you have to manually add data this won't be automatically. You can do several things:

1- Create a table visualization with the first column and export that data. Then open de csv file, make it a table and add the second column.

2- Create a new dax table like DISTINCT(Table[Column1]) or ALL(Table[Column1]). Go to view data right click and copy table to an excel file where you can continue with the second column.

3- Similar to the number 2, you may be able to paste the copy of the data in "Enter Data" option on power bi to add directly to power bi instead of going through excel.

Regards,

[EVEAdmin]

@ibarrau thank you

That will make the process static, whereas I need it to be dynamic. 

[Anonymous]

Define "manually filled"?
You can use a combination of ADDCOLUMNS, SELECTCOLUMNS and DISTINCT

something like

ADDCOLUMNS(SELECTCOLUMNS(DISTINCT(yourtable[yourcolumn])); "new column"; new values)

[EVEAdmin]

@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?

[Anonymous · Accepted solution]

"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.

[EVEAdmin]

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.

[Anonymous]

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.

[EVEAdmin]

@Anonymous thank you for your help.