Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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"
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!
A
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |