> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation.md).

# Documentation

- [Plan](https://docs.fabricplan.com/documentation/plan.md): No-code, Full-stack Planning + BI + Data Management Suite on Microsoft Fabric
- [Prerequisites for Plan](https://docs.fabricplan.com/documentation/plan/prerequisites-for-plan.md)
- [Create and share a cloud connection for a semantic model](https://docs.fabricplan.com/documentation/plan/create-and-share-a-cloud-connection-for-a-semantic-model.md)
- [Create a database connection for collaboration](https://docs.fabricplan.com/documentation/plan/create-a-database-connection-for-collaboration.md)
- [Creating a Planning Sheet](https://docs.fabricplan.com/documentation/plan/creating-a-planning-sheet.md)
- [Known Limitations in Plan](https://docs.fabricplan.com/documentation/plan/known-limitations-in-plan-preview.md)
- [Row-level security (RLS) behavior in Plan](https://docs.fabricplan.com/documentation/plan/row-level-security-rls-behavior-in-plan.md)
- [Roles in Fabric Plan](https://docs.fabricplan.com/documentation/plan/roles-in-fabric-plan.md)
- [Disaster recovery for Plan](https://docs.fabricplan.com/documentation/plan/disaster-recovery-for-plan.md): Experience-Specific Recovery Procedures for Planning in Fabric IQ
- [Planning sheets](https://docs.fabricplan.com/documentation/plan/planning-sheets.md)
- [Concepts](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts.md)
- [Fiscal year setup in plan](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/fiscal-year-setup-in-plan.md)
- [Cube - Multidimensional planning](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/cube.md)
- [Row Model: "The Agile Driver Framework"](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/row-model-the-agile-driver-framework.md)
- [Measure Model: "The Semantic Enrichment Framework"](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/measure-model-the-semantic-enrichment-framework.md)
- [PREDICT: Statistical Forecasting Algorithm](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/predict-statistical-forecasting-algorithm.md)
- [Top-down Planning](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/concepts.md)
- [Bottom-up Planning](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/bottom-up-planning.md)
- [Reforecasting](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/reforecasting.md)
- [Writeback](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/writeback.md)
- [Approval workflow](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/approval-workflow.md)
- [Closing forecast period](https://docs.fabricplan.com/documentation/plan/planning-sheets/concepts/closing-forecast-period.md)
- [How-tos](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos.md)
- [Create a database connection](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/create-a-database-connection.md)
- [Forecast data to predict future trends](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends.md)
- [Create a P\&L forecast](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-a-p-and-l-forecast.md)
- [Create multi-dimensional forecasts](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-multi-dimensional-forecasts.md)
- [Manage rolling forecasts](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/manage-rolling-forecasts.md)
- [Generate Statistical Forecasts using PREDICT feature](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/generate-forecasts-from-statistical-data.md)
- [Extend planning beyond source data periods](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/extend-planning-beyond-source-data-periods.md)
- [Edit forecast settings](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/edit-forecast-settings.md)
- [Allocate deficits to meet targets](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/allocate-deficits-to-meet-targets.md)
- [Forecasting FAQ](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/forecast-data-to-predict-future-trends/forecasting-faq.md)
- [Commenting and collaboration](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/commenting-and-collaboration.md)
- [Notes in Commenting and Collaboration](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/commenting-and-collaboration/notes-in-commenting-and-collaboration.md)
- [Extend Planning sheet with data input](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/extend-planning-sheet-with-data-input.md)
- [Multidimensional planning and forecasting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/multidimensional-planning-and-forecasting.md)
- [Plan across multiple dimensions with cubes](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/multidimensional-planning-and-forecasting/allocate-values-across-dimensions.md)
- [Multidimensional expense allocation](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/multidimensional-planning-and-forecasting/multidimensional-expense-allocation.md)
- [Multidimensional forecasting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/multidimensional-planning-and-forecasting/multidimensional-forecasting.md)
- [Cube best practices and FAQs](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/multidimensional-planning-and-forecasting/cube-best-practices-and-faqs.md)
- [Manage cube measures](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/multidimensional-planning-and-forecasting/manage-cube-measures.md)
- [Analyze planning outcomes with scenarios](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/analyze-planning-outcomes-with-scenarios.md)
- [Bookmarks](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/bookmarks.md)
- [Exports in the Planning sheet](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/exports-in-the-planning-sheet.md)
- [Pivot](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/pivot.md)
- [Layouts](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/layouts.md)
- [Conditional formatting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/conditional-formatting.md)
- [Create rules in Conditional Formatting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting.md)
- [Format by Rules (If conditions) in conditional formatting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-rules-if-conditions-in-conditional-formatting.md)
- [Page 1](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/page-1.md)
- [Format by Color scale conditional formatting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-color-scale-conditional-formatting.md)
- [Format by classification conditional formatting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/conditional-formatting/create-rules-in-conditional-formatting/format-by-classification-conditional-formatting.md)
- [Quick formatting options](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/conditional-formatting/quick-formatting-options.md)
- [Manage Rules](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/conditional-formatting/manage-rules.md)
- [Persist data with Writeback](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback.md)
- [Writeback in Plan](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/writeback-in-plan.md)
- [General Settings](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/general-settings.md)
- [Data Settings](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/data-settings.md)
- [Destination Settings](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/destination-settings.md)
- [Configure advanced settings](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/configure-advanced-settings.md)
- [Configure writeback destinations](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/configure-writeback-destinations.md)
- [View Logs](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/view-logs.md)
- [Enable writeback in reading mode](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/enable-writeback-in-reading-mode.md)
- [FAQs on Writeback](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/faqs-on-writeback.md)
- [Layout options](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/layout-options.md)
- [Basic formatting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/basic-formatting.md)
- [Number formatting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/basic-formatting/number-formatting.md): Plan for Power BI comes prepackaged with intelligent number formatting & scaling recognition capabilities that help display data in a perceptive manner in your table/matrix style reports.
- [Cell, header & value formatting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/basic-formatting/cell-header-and-value-formatting.md)
- [Total and Subtotals](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/basic-formatting/total-and-subtotals.md)
- [Adding business logic and formulas](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae.md)
- [Edit cells](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/editing-cells.md)
- [Rows](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows.md)
- [Insert data input rows](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows.md)
- [Insert template rows](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/template-rows.md)
- [Insert formula rows](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-calculated-rows.md)
- [Insert blank rows](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-blank-rows.md)
- [Insert forecast rows](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-forecast-rows.md)
- [Measures and Columns](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns.md)
- [Insert data input columns](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns.md)
- [Number](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/insert-manual-input-columns.md)
- [Dropdown](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/dropdown.md)
- [Dropdown options from semantic models](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/dropdown/dropdown-options-from-semantic-models.md)
- [Lookup visuals for dropdowns](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/dropdown/lookup-visuals-for-dropdowns.md)
- [Text, checkbox & date](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/text-checkbox-and-date.md)
- [Person](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/writeback-matrix-features.md)
- [Importing data](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/importing-data.md)
- [Insert Formula columns](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-calculated-columns.md)
- [Importing data](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/importing-data.md)
- [Invert sign](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/invert-sign.md)
- [Quick formula](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/quick-formula.md)
- [Visual column inside visual measures](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/visual-column-inside-visual-measures.md)
- [Manage inserted rows](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns.md)
- [Manage inserted measures & columns](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns-1.md)
- [Manage aggregation](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-aggregation.md): Custom Measure Aggregations in Semantic Models with Plan
- [Row aggregation](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-aggregation/row-aggregation.md)
- [Pivot data](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/pivot-data.md)
- [Conditional formatting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting.md): Plan enables intuitive data classification using conditional formatting, allowing users to visually interpret performance at a glance
- [One-click options](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/one-click-options.md)
- [Create rule](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings.md): You can build your own conditional formatting rules from scratch or customize the rules created using the one-click options if your report requires it.
- [Rules (If conditions)](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/rules-if-conditions.md)
- [Color scale & data bars](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/color-scale.md)
- [Classification](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/classification.md): Learn how to use classification-based conditional formatting - such as text, icons, and ratings - to quickly gain insights from your reports.
- [Ranking](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/ranking.md): Plan highlights the top or bottom N ranked values, making it easy to quickly identify the highest- and lowest-performing items.
- [Field Value](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/field-value.md): Learn how to use field value–based conditional formatting to dynamically format your Microsoft Fabric reports using Plan.
- [Bubble Charts](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/bubble-charts.md): In this section, we'll look at bubble charts. Note that you can either create a new rule as shown here or edit the bubble charts inserted using the one-click option explained here.
- [Action Dots](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/action-dots.md): Learn how to use Action Dots to visually represent performance for faster, more efficient analysis in Plan.
- [Manage rules](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/manage-rules.md)
- [Planning, Budgeting & Forecasting](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting.md)
- [What-if Analysis & Simulations](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/what-if-analysis-and-simulations.md)
- [Scenario](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/scenario.md)
- [Compare Scenarios](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/scenario/compare-scenarios.md)
- [Goal Seek](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/goal-seek.md)
- [Budgeting & Allocations](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/budgeting-and-allocations.md)
- [Allocation Rules and Controls](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls.md)
- [Locking Rule](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls/locking-rule.md)
- [Distribution rules](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls/distribution-rules.md)
- [Min-Max Rule](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/allocation-rules-and-controls/min-max-rule.md)
- [Column aggregation](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/column-aggregation.md)
- [Commenting and Collaboration](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration.md): Collaborate seamlessly with comments and notes
- [Notes](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/notes.md): Annotate data with notes to add descriptive context
- [Comments](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments.md): Discuss data, assign tasks, and track changes using comments
- [Data-level comments](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments/comments.md): Comment on data and collaborate using mentions and replies
- [Assign tasks & monitor progress](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments/comments-1.md): Assign comments as tasks and track their status across stakeholders
- [Filter & track changes](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments/track-changes.md): Filter and track comment activity across the report
- [Report-level comments](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments/report-level-comments.md): Leverage report-level comments to collaborate, assign tasks, and provide an overall summary of the report
- [Comment settings](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/8.-commenting-and-collaboration/comments/comment-settings.md): Configure comment settings to control access, thread behavior, and notifications
- [Exporting reports](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/10.-exporting-reports.md)
- [Export to PDF & Excel](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/10.-exporting-reports/export.md)
- [Export to Excel](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/10.-exporting-reports/export/export-to-excel.md)
- [Export to PDF](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/10.-exporting-reports/export/export-to-pdf.md)
- [Snapshot](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/10.-exporting-reports/snapshot-writeback-matrix-only.md)
- [Comparing snapshots](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/10.-exporting-reports/snapshot-writeback-matrix-only/comparing-snapshots.md)
- [Use row models](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/use-row-models.md)
- [Create a row model](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/use-row-models/create-a-row-model.md)
- [Create forecasts using row model](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/use-row-models/create-forecasts-using-row-model.md)
- [Perform scenario analysis in row model](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/use-row-models/perform-scenario-analysis-in-row-model.md)
- [Create a model using Model Builder](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/use-row-models/create-a-model-using-model-builder.md)
- [Configure row properties in the model](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/use-row-models/configure-row-properties-in-the-model.md)
- [Create a driver-based model](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/use-row-models/create-a-driver-based-model.md)
- [Create templates for reusable row structures](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/use-row-models/create-templates-for-reusable-row-structures.md)
- [Tree view](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/use-row-models/tree-view.md)
- [Visualize the model using the tree layout](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/use-row-models/visualize-the-model-using-the-tree-layout.md)
- [Optimize overview](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/optimize-overview.md)
- [Maximize or minimize a target value](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/optimize-overview/maximize-or-minimize-a-target-value.md)
- [Optimize input values to meet a target](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/optimize-overview/optimize-input-values-to-meet-a-target.md)
- [Use Optimize on derived measures and allocation rules](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/optimize-overview/use-optimize-on-derived-measures-and-allocation-rules.md)
- [Configure approval workflows](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/configure-approval-workflows.md)
- [Measure-based modelling](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/measure-based-modelling.md)
- [Manage security in planning](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/manage-security-in-planning.md)
- [Formula syntax](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax.md)
- [Conditional statements](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/conditional-statements.md)
- [IF](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/conditional-statements/if-1.md)
- [IFNA](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/conditional-statements/ifna.md)
- [AVERAGEIF](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/conditional-statements/if.md)
- [COUNTIF](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/conditional-statements/countif.md)
- [SUMIF](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/conditional-statements/sumif.md)
- [FILTERIF](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/conditional-statements/filterif.md)
- [SWITCH](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/conditional-statements/switch.md)
- [Logical functions](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/logical-functions.md)
- [AND](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/logical-functions/and.md)
- [OR](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/logical-functions/or.md): Evaluates multiple conditions and returns TRUE if at least one condition is satisfied.
- [NOT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/logical-functions/not.md): Reverses a logical result and returns the opposite boolean value
- [XOR](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/logical-functions/xor.md): Evaluates multiple conditions and returns TRUE only if exactly one or an odd number of conditions are met.
- [IN](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/logical-functions/in.md): Checks if a value matches the values within a given list or array of values and returns TRUE if it matches.
- [ISBLANK](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/logical-functions/isblank.md): Checks whether a cell is blank and returns TRUE or FALSE.
- [ISNUMBER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/logical-functions/isnumber.md): Checks whether a cell value is a valid number and returns TRUE or FALSE.
- [ISREFEXIST](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/logical-functions/isrefexist.md): Verifies whether a reference exists and returns a logical result.
- [Math functions](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions.md)
- [ABS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/abs.md)
- [AVERAGE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/average.md)
- [AVERAGEEXNEG](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/averageexneg.md)
- [AVERAGEEXZERO](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/averageexzero.md)
- [AVERAGEEXZERONEG](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/averageexzeroneg.md)
- [CEILING](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/ceiling.md)
- [COUNT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/count.md)
- [DIVIDE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/divide.md)
- [EVEN](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/even.md)
- [EXP](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/exp.md)
- [ODD](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/odd.md)
- [FLOOR](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/floor.md)
- [INDEXOF](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/indexof.md)
- [LARGE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/large.md)
- [LOG](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/log.md)
- [MAX](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/max.md)
- [MIN](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/min.md)
- [MOD](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/mod.md)
- [MROUND](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/mround.md)
- [NUMBERVALUE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/numbervalue.md)
- [PCT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/pct.md)
- [POWER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/power.md)
- [PRODUCT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/product.md)
- [RAND](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/rand.md)
- [RANDBETWEEN](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/randbetween.md)
- [ROUND](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/round.md)
- [ROUNDDOWN](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/rounddown.md)
- [ROUNDUP](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/roundup.md)
- [SORT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/sort.md)
- [SUBTRACT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/subtract.md)
- [SUM](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/sum.md)
- [SMALL](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/small.md)
- [SQRT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/sqrt.md)
- [PMT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/math-functions/pmt.md)
- [Text formatting functions](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions.md)
- [CONCATENATE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/concatenate.md): Joins multiple text strings into one single combined text value.
- [CONCATALL](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/concatall.md)
- [HYPERLINK](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/hyperlink.md)
- [LEFT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/left.md)
- [LOWER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/lower.md)
- [MID](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/mid.md)
- [PROPER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/proper.md)
- [REPLACE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/replace.md)
- [REPT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/rept.md)
- [RIGHT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/right.md)
- [TEXT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/text.md)
- [TRIM](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/trim.md)
- [UPPER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/upper.md): Converts text to uppercase letters.
- [VALUE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/value.md)
- [LEN](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/text-formatting-functions/len.md): Returns the number of characters in a text string, including spaces and special characters.
- [Date functions](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions.md): Date functions allow you to create, format, extract, calculate, and manipulate date and time values.
- [DATEADD](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/dateadd.md)
- [DATEDIFF](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/datediff.md)
- [DAY](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/day.md)
- [DATE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/date.md)
- [DATE.FORMAT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/date.format.md)
- [SOWEEK](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/soweek.md)
- [SOMONTH](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/somonth.md)
- [SOQTR](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/soqtr.md)
- [SOYEAR](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/soyear.md)
- [EOWEEK](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/eoweek.md)
- [EOMONTH](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/eomonth.md)
- [EOQTR](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/eoqtr.md)
- [EOYEAR](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/eoyear.md)
- [NETWORKDAYS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/networkdays.md)
- [ADDDAYS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/adddays.md)
- [ADDWEEKS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/addweeks.md)
- [ADDMONTHS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/addmonths.md)
- [ADDQTRS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/addqtrs.md)
- [ADDYEARS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/addyears.md)
- [FROM\_EXCELDATE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/fromexceldate.md)
- [MONTH](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/month.md)
- [DATE.NOW](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/now.md)
- [PERIOD\_RANGE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/period_range.md)
- [TO\_EXCELDATE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/toexceldate.md)
- [YEAR](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/date-functions/year.md)
- [Time intelligence functions](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions.md)
- [Relative time periods](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/relative-time-periods.md)
- [Specific time periods](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/specific-time-periods.md)
- [Period-to-date calculations](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/period-to-date-calculations.md)
- [Time-based aggregations](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/time-based-aggregations.md)
- [Time shifting and lookup](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/time-intelligence-functions/time-shifting-and-lookup.md)
- [Other operators](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/other-operators.md)
- [Identifiers](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/identifiers.md)
- [Identifiers](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/identifiers/identifiers.md)
- [Scripting functions](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions.md)
- [DISPLAYTOAST](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/displaytoast.md)
- [EXPORT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/export.md)
- [LAYOUT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/layout.md)
- [OPENFILTER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/openfilter.md)
- [OPENKPIEXPLORER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/openkpiexplorer.md)
- [OPENMANAGECOLUMN](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/openmanagecolumn.md)
- [OPENSEARCH](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/opensearch.md)
- [OPENTOPN](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/opentopn.md)
- [SENDMAIL](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/sendmail.md)
- [SETCFRULE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setcfrule.md)
- [SETCOLUMNSORT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setcolumnsort.md)
- [SETFILTER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setfilter.md)
- [SETFILTERBYINDEX](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setfilterbyindex.md)
- [SETFONTSIZE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setfontsize.md)
- [SETFOOTER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setfooter.md)
- [SETHEADER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setheader.md)
- [SETLOCK](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setlock.md)
- [SETMEASURETITLE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setmeasuretitle.md)
- [SETMAXDECIMALPRECISION](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setmaxdecimalprecision.md)
- [SETPAGINATION](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setpagination.md)
- [SETSCALING](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setscaling.md)
- [SETSEMANTICFORMATTING](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setsemanticformatting.md)
- [SETSTATUSBAR](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setstatusbar.md)
- [SETVALUE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setvalue.md)
- [SETVISIBILITY](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/setvisibility.md)
- [SHOWBETWEENPERIOD](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/showbetweenperiod.md)
- [SHOWCLOSEDFORECAST](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/showclosedforecast.md)
- [SHOWMEASUREBETWEENPERIOD](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/showmeasurebetweenperiod.md)
- [TOPN](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/topn.md)
- [DISPLAY SETTINGS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings.md)
- [SETBLANKLABEL](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/setblanklabel.md)
- [SETSUPPRESSZEROS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/setsuppresszeros.md)
- [SETRAGGEDHIERARCHY](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/setraggedhierarchy.md)
- [SEPARATOR](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/separator.md)
- [SETCOMBINECOLUMNHEADER](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/setcombinecolumnheader.md)
- [SEMANTICFORMAT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/semanticformat.md)
- [SHOWNULLAS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/shownullas.md)
- [SHOWZEROAS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/showzeroas.md)
- [SINGLECHILD](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/scripting-functions/display-settings/singlechild.md)
- [Statistical Functions](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/statistical-functions.md): Analyze data using statistical functions to summarize, measure variation, and uncover insights.
- [Calculate measures of central tendency](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/statistical-functions/calculate-measures-of-central-tendency.md)
- [Calculate ranking and quartiles](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/statistical-functions/calculate-ranking-and-quartiles.md)
- [Calculate variance and standard deviation](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/statistical-functions/calculate-variance-and-standard-deviation.md)
- [Calculate percentiles and percent ranks](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/statistical-functions/calculate-percentiles-and-percent-ranks.md)
- [Calculate normal distribution values](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/statistical-functions/calculate-normal-distribution-values.md)
- [Miscellaneous functions](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/miscellaneous-functions.md)
- [FETCH](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/miscellaneous-functions/fetch.md)
- [LOOKUP](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/miscellaneous-functions/lookup.md)
- [Measure/Column selection functions](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/measure-column-selection-functions.md)
- [GETCOLBETWEENPERIODS](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/measure-column-selection-functions/getcolbetweenperiods.md)
- [GETMEASURE](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/measure-column-selection-functions/getmeasure.md)
- [SELECT](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/measure-column-selection-functions/select.md)
- [SELECT\_BYINDEX](https://docs.fabricplan.com/documentation/plan/planning-sheets/formula-syntax/measure-column-selection-functions/select_byindex.md)
- [Backup & restore report config](https://docs.fabricplan.com/documentation/plan/planning-sheets/export-and-import-reports-backup.md)
- [Troubleshoot](https://docs.fabricplan.com/documentation/plan/planning-sheets/troubleshoot.md)
- [PowerTable sheets](https://docs.fabricplan.com/documentation/plan/powertable-sheets.md)
- [Concepts](https://docs.fabricplan.com/documentation/plan/powertable-sheets/concepts.md)
- [Layouts](https://docs.fabricplan.com/documentation/plan/powertable-sheets/concepts/layouts.md)
- [Gantt layout](https://docs.fabricplan.com/documentation/plan/powertable-sheets/concepts/gantt-layout.md)
- [Automation](https://docs.fabricplan.com/documentation/plan/powertable-sheets/concepts/automation.md)
- [Slowly changing dimensions](https://docs.fabricplan.com/documentation/plan/powertable-sheets/concepts/type-2-scds.md)
- [How-tos](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos.md)
- [Create a table app](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/create-a-table-app.md)
- [Build a no-code table app with PowerTable](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/create-a-table-app/create-a-table-app-with-powertable-sheets.md)
- [Connect PowerTable sheet to a semantic model](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/create-a-table-app/connect-powertable-sheet-to-a-semantic-model.md)
- [Connect to a Database](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/create-a-table-app/connect-to-a-database.md)
- [Enter Data Manually](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/create-a-table-app/enter-data-manually.md)
- [Create PowerTable Sheets FAQ](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/create-a-table-app/create-powertable-sheets-faq.md)
- [Data management](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/basic-table-operations.md)
- [Edit and Bulk-edit data](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/basic-table-operations/edit-and-bulk-edit-data.md)
- [Preview Changes](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/basic-table-operations/preview-changes.md)
- [Insert, import, duplicate, and delete rows](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/insert-import-duplicate-and-delete-rows.md)
- [Add Columns - Overview](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/adding-columns-overview.md)
- [Add visual column overview](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column.md)
- [Multiselect relationship column](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/multi-select-relationship-column.md)
- [Reference Column](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/reference-column.md)
- [Relation Column](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/relation-column.md)
- [Rollup Column](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/rollup-column.md)
- [Button Column](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/button-column.md)
- [Attachment Column](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/attachments-column.md)
- [Add Database Column](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-database-column.md)
- [Add Formula Column](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/adding-columns-overview/add-formula-column.md)
- [Configure column properties](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/configure-column-properties.md)
- [General](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/configure-column-properties/general.md)
- [Display](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/configure-column-properties/display.md)
- [Lookup and relation](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/configure-column-properties/lookup-and-relation.md)
- [Set up row and column access control](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/set-up-row-and-column-access-control.md)
- [Manage Columns](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/manage-columns.md)
- [Change column widths](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/manage-columns/change-column-widths.md)
- [Configure layouts](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/layout-views-summary.md)
- [Hierarchy](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/layout-views-summary/hierarchy-layout.md)
- [Crosstab](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/layout-views-summary/crosstab.md)
- [Resource](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/layout-views-summary/resource.md)
- [Overview](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/layout-views-summary/resource/overview.md)
- [Add and manage tasks](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/layout-views-summary/resource/add-and-manage-tasks.md)
- [Customize resource layout](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/layout-views-summary/resource/resource-view.md)
- [Gantt](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/layout-views-summary/gantt-chart-view.md)
- [Calendar](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/layout-views-summary/calendar-layout.md)
- [Kanban](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/layout-views-summary/kanban-layout.md)
- [Create data entry forms](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/generate-forms.md)
- [Approval flow](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/approval-flow.md)
- [Configure approval workflow](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/approval-flow/configure-approval-workflow.md)
- [Review changes in PowerTable approval workflow](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/approval-flow/review-changes-in-powertable-approval-workflow.md)
- [Automation](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/automation.md)
- [Configure automation workflows](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/automation/configure-automation-workflows.md)
- [Create a sample automation](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/automation/create-a-sample-automation.md)
- [Commenting and collaboration](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/commenting-and-collaboration.md)
- [Export to Excel](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/export-powertable-sheet.md)
- [Export to PDF](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/export-to-pdf.md)
- [Conditional Formatting](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/conditional-formatting.md)
- [Audit log](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/audit-log.md)
- [Create slowly changing dimensions](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/create-slowly-changing-dimensions.md)
- [Explore and organize data](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/explore-and-organize-data.md)
- [Filter data](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/explore-and-organize-data/filter-data.md)
- [Group rows](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/explore-and-organize-data/group-rows.md)
- [Appearance settings](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/appearance-settings.md)
- [Configure security settings in PowerTable](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/configure-security-settings-in-powertable.md)
- [Reference](https://docs.fabricplan.com/documentation/plan/powertable-sheets/reference.md)
- [Supported column and input types](https://docs.fabricplan.com/documentation/plan/powertable-sheets/reference/supported-column-types.md)
- [Supported file types for attachment](https://docs.fabricplan.com/documentation/plan/powertable-sheets/reference/supported-file-types-for-attachment.md)
- [Intelligence sheets](https://docs.fabricplan.com/documentation/plan/intelligence-sheets.md)
- [How-tos](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos.md)
- [Get started with Intelligence sheets](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/get-started-with-intelligence-sheets.md)
- [Get started with reporting](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/get-started-with-reporting.md)
- [Apply conditional formatting](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-conditional-formatting.md)
- [Showcase data points in charts](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-conditional-formatting/showcase-data-points-in-charts.md)
- [Highlight tabular data with conditional formatting](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-conditional-formatting/highlight-tabular-data-with-conditional-formatting.md)
- [Create rules](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-conditional-formatting/create-rules.md)
- [Build financial reports](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/build-financial-reports.md)
- [Collaborate on reports with comments](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/collaborate-on-reports-with-comments.md)
- [Pagination and formatting for reports](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/pagination-and-formatting-for-reports.md)
- [Export high-quality PDF & Excel reports](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/export-high-quality-pdf-and-excel-reports.md)
- [Visualize simulations, budgets, and forecasts](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/visualize-simulations-budgets-and-forecasts.md)
- [Monitor project progress with Gantt charts](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/plan-projects-with-gantt-charts.md)
- [Retain report data with Writeback](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/retain-report-data-with-writeback.md)
- [Build multi-measure charts](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/build-multi-measure-charts.md)
- [Use themes for consistent color schemes](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/use-themes-for-consistent-color-schemes.md)
- [Ranking data](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/ranking-data.md)
- [Sorting data](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/sorting-data.md)
- [Filter data](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/filter-data.md)
- [Add date filters](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/filter-data/add-date-filters.md)
- [Create a filter panel](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/filter-data/create-a-filter-panel.md)
- [Add a treemap filter](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/filter-data/add-a-treemap-filter.md)
- [Add a hierarchy filter](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/filter-data/add-a-hierarchy-filter.md)
- [Build a dashboard](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/build-a-dashboard.md)
- [Apply IBCS formats](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats.md)
- [Column and bar charts](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/column-and-bar-charts.md)
- [Waterfall charts](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/waterfall-charts.md)
- [Area and line charts](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/area-and-line-charts.md)
- [Scatter and bubble charts](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/scatter-and-bubble-charts.md)
- [Small multiples](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/small-multiples.md)
- [Table templates](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/table-templates.md)
- [Visualization library](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/visualization-library.md)
- [Sankey chart](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/visualization-library/sankey-chart.md)
- [Boxplot](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/visualization-library/boxplot.md)
- [Multi axis chart](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/visualization-library/multi-axis-chart.md)
- [Slope graph](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/visualization-library/slope-graph.md)
- [Network graph](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/visualization-library/network-graph.md)
- [Compare data with small multiples](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/compare-data-with-small-multiples.md)
- [Intelligence FAQ](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/intelligence-faq.md)
- [Infobridge](https://docs.fabricplan.com/documentation/plan/infobridge.md)
- [Concepts](https://docs.fabricplan.com/documentation/plan/infobridge/concepts.md)
- [Connected planning](https://docs.fabricplan.com/documentation/plan/infobridge/concepts/connected-planning.md)
- [How-tos](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos.md)
- [Create a bridge to integrate and transform plans](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/1.-create-bridge.md)
- [Manage query operations](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/4.-manage-queries.md)
- [Share measures](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/share-measures.md)
- [Consolidate data between sheets](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/import-measures-between-planning-sheets.md)
- [Import data into a bridge](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/2.-add-source-to-bridge.md)
- [Query transformations](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/query-transformations.md)
- [Append Queries](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/query-transformations/append.md)
- [Join queries](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/query-transformations/join.md): Explore how to leverage joins to retrieve data from multiple tables using a related column.
- [Merge queries](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/query-transformations/merge-queries.md)
- [Duplicate](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/query-transformations/duplicate.md)
- [SQL queries](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/query-transformations/sql-queries.md)
- [Writeback transformed data from InfoBridge](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/writeback-transformed-data-from-infobridge.md)
- [4. Manage sources](https://docs.fabricplan.com/documentation/plan/infobridge/4.-manage-sources.md)
- [6. Insert measure from bridge](https://docs.fabricplan.com/documentation/plan/infobridge/6.-insert-measure-from-bridge.md)
- [7. Manage Integration of Plan items](https://docs.fabricplan.com/documentation/plan/infobridge/7.-manage-integration-of-visuals.md)
- [8. Manage Bridges](https://docs.fabricplan.com/documentation/plan/infobridge/8.-manage-bridges.md)
- [9. Data transformations](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations.md)
- [Use pivot table](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/pivot-table.md)
- [Group by transformations](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/group-by.md): Learn how to aggregate and summarize detailed reports with the Group by transformation.
- [Add Column](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/add-column.md)
- [Pivot and unpivot columns](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/pivot-columns-unpivot-columns.md)
- [Rename column](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/rename-column.md)
- [Use Find and Replace](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/find-and-replace.md)
- [Remove column](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/remove-column.md)
- [Filter rows](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/filter-rows.md)
- [Sort](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/sort.md)
- [Text functions](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/text-functions.md)
- [Unnest](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/unnest.md): Learn how to use the Unnest transformation to convert delimited values into separate rows and flatten your data.
- [Round](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/round.md)
- [Extract Comments](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/extract-comments.md)
- [Import and export transformation steps](https://docs.fabricplan.com/documentation/plan/infobridge/9.-data-transformations/import-and-export.md)
- [10. Integrating forecasts](https://docs.fabricplan.com/documentation/plan/infobridge/10.-integrating-forecasts.md)
- [11. Collaborative adjustments](https://docs.fabricplan.com/documentation/plan/infobridge/11.-collaborative-adjustments.md)
- [Infobridge sheets in Plan](https://docs.fabricplan.com/documentation/plan/infobridge/infobridge-sheets-in-plan-preview.md)
- [Disaster recovery guidance](https://docs.fabricplan.com/documentation/plan/disaster-recovery-guidance.md): Experience-Specific Recovery Procedures for Planning in Fabric IQ


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.fabricplan.com/documentation.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.