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.

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.

      • EVEAdmin's avatar
        EVEAdmin
        Post Patron
        6 years ago

        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.