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:

  1. column one contains distinct values from a column in another table
  2. 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.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

      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's avatar
        Anonymous
        Not applicable
        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.