6.3 The Power Query Ribbon at a Glance
| Tab | Main groups and commands |
|---|---|
| Home | Close & Apply, New Source, Recent Sources, Enter Data, Data source settings, Manage Parameters, Refresh Preview, Advanced Editor, Choose/Remove Columns, Keep/Remove Rows, Sort, Split Column, Group By, Data Type, Use First Row as Headers, Replace Values, Merge Queries, Append Queries, Combine Files |
| Transform | Table: Group By, Use First Row as Headers, Transpose, Reverse Rows, Count Rows · Any Column: Data Type, Detect Data Type, Rename, Replace Values, Fill, Pivot Column, Move, Unpivot Columns · Text Column: Split Column, Format, Merge Columns, Extract, Parse · Number Column: Statistics, Standard, Scientific, Trigonometry, Rounding, Information · Date & Time Column: Date, Time, Duration |
| Add Column | General: Column From Examples, Custom Column, Invoke Custom Function, Conditional Column, Index Column, Duplicate Column · From Text · From Number · From Date & Time (full coverage in Module 8) |
| View | Query Settings, Formula Bar, Monospaced, Show whitespace, Column quality, Column distribution, Column profile, Go to Column, Advanced Editor, Query Dependencies |
| Tools / Help | Diagnostics (query diagnostics), help links |
Transform tab vs Add Column tab
Lakshat theva, many commands appear on both tabs. On the Transform tab they change the existing column. On the Add Column tab they create a new column and keep the original. Choose carefully.
Ravindra Bagale's Tip
Friends, many students hunt through the ribbon for every transformation. Right-click the column header, or use the small table icon at the top-left of the data grid. Most common transformations are one click away there. Don't make this mistake!
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students प्रत्येक transformation साठी ribbon मध्ये शोधत बसतात. Column header वर right-click करा, किंवा data grid च्या top-left ला असलेला छोटा table icon वापरा. बहुतेक common transformations तिथे एका click वर मिळतात. ही चूक करू नका!
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students हर transformation के लिए ribbon में ढूँढते रहते हैं. Column header पर right-click करो, या data grid के top-left में छोटा table icon इस्तेमाल करो. ज़्यादातर common transformations वहाँ एक click पर मिल जाते हैं. यह गलती मत करना!