Power BI · मराठी आवृत्ती
6.3 Power Query ribbon एका नजरेत
| 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 चा पर्याय निवडा.