Forum Discussion
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 Data
Name Code
X [123,234]
r [32,34]
If I used original table I can go into edit query & use split option, replace option & then unpivot to get below result. But If I create NEW table it does not allow to edit it.
output required
Name Code
X 123
X 234
r 32
r 34
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"
3 Replies
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"Hey KL718
What is the source?
Is it SQL?
Why not query with relvant data only?select col1, col2, colN from Table
Cheers!
ASource 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.
