# 6.3 Power Query ribbon एका नजरेत

Source: https://ravindrabagale.com/mr/powerbi/ch06-power-query-essentials/6-3-the-power-query-ribbon-at-a-glance.html
Language: mr (Marathi with English technical terms)

| Tab | 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 / Any Column | Group By, Use First Row as Headers, Transpose, Reverse Rows, Count Rows, Data Type, Detect Data Type, Rename, Replace Values, Fill, Pivot Column, Move, Unpivot Columns

 | Transform — Text / Number / Date | Text: Split, Format, Merge, Extract, Parse. Number: Statistics, Standard, Scientific, Trigonometry, Rounding, Information. Date / Time: Date, Time, Duration.

 | Add Column | Column From Examples, Custom Column, Invoke Custom Function, Conditional Column, Index Column, Duplicate Column; From Text, From Number, From Date & Time. Chapter 8 मध्ये तपशील.

 | View | Query Settings, Formula Bar, Monospaced, Show whitespace, Column quality, Column distribution, Column profile, Go to Column, Advanced Editor, Query Dependencies

 | Tools / Help | Query Diagnostics आणि help links.

Transform आणि Add Column फरक

दोन्हीकडे सारखी command दिसू शकते. Transform existing column बदलतो. Add Column मूळ column ठेवून नवीन तयार करतो. उदाहरणार्थ नाव uppercase करायचं आणि मूळ नावही ठेवायचं असेल तर Add Column चा पर्याय निवडा.

रवींद्र बागले यांची tip

Column header वर right-click किंवा grid च्या वरच्या डाव्या table icon मधूनही अनेक transformations पटकन मिळतात.