Forum Discussion

pshetty05's avatar
pshetty05
Helper I
6 years ago

Create a new table through sql query using the existing table that was loaded via excelsheet

Hello,   I have table A that has 2 values - Email address & Client Status which has been created using an excelsheet.   Now, I want to create another table that uses the values from this table to...
Need Help
  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    pshetty05 , Missed your last update. Option in edit query

    Copy a table and remove column not need and remove duplicates

    Select the required column, Right-click , last option add as new query and remove duplicates, convert to tables.

     

    In DAX, you selectcoulmns, summarize, summarizecolumns