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"
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
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"