Forum Discussion

EVEAdmin's avatar
EVEAdmin
Post Patron
6 years ago
Solved

Create New Table

Hi all I would like to create a new table with 2 columns, where: column one contains distinct values from a column in another table column two is manually filled Is that possible ? Then, how?
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

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

ibarrau's avatar
ibarrau
Super User
6 years ago

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's avatar
EVEAdmin
Post Patron
6 years ago

ibarrau thank you

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