Forum Discussion

KL718's avatar
KL718
Frequent Visitor
7 years ago
Solved

How to edit New Table in edit query

I have table with (30K ROws, 30 Columns). I need 3 columns & all rows. I used New Table option with summarize option. Now I cannot edit it iin edit query.   What is the workaround.    Current Dat...
Need Help
Tips and Tricks
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    KL718 

     

    Calculated tables created with DAX are not visible in the Query Editor. You may Reference queries in the Query Editor and change code in The Advanced Editor.

    let
    Source = Table1,
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Column1", "Column2"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns")
in
    #"Removed Duplicates"
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey KL718 

What is the source?
Is it SQL?
Why not query with relvant data only?

select col1, col2, colN from Table

 

Cheers!
A

KL718's avatar
KL718
Frequent Visitor
7 years ago

Source is Excel file. I do not want to use original file since the output what i want will be moved from column to row level thus creating duplication for all 30 K rows & 30 columns which I do not want.

 

I just want to subset the data & oull only 3 columns & work on it.