> 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/planning-sheets.md). # Planning Sheets - [Concepts](https://docs.fabricplan.com/planning-sheets/concepts.md) - [Measure and row-based planning](https://docs.fabricplan.com/planning-sheets/concepts/measure-and-row-based-planning.md) - [Measure Model - the semantic enrichment framework](https://docs.fabricplan.com/planning-sheets/concepts/measure-and-row-based-planning/measure-model-the-semantic-enrichment-framework.md) - [Row model - the agile driver framework](https://docs.fabricplan.com/planning-sheets/concepts/measure-and-row-based-planning/row-model-the-agile-driver-framework.md) - [Cube - Multidimensional planning](https://docs.fabricplan.com/planning-sheets/concepts/measure-and-row-based-planning/cube.md) - [Planning tools](https://docs.fabricplan.com/planning-sheets/concepts/planning-tools.md) - [Allocation rules and data input controls in planning sheet](https://docs.fabricplan.com/planning-sheets/concepts/planning-tools/allocation-rules-and-data-input-controls-in-planning-sheet.md) - [Approval workflow](https://docs.fabricplan.com/planning-sheets/concepts/planning-tools/approval-workflow.md) - [Scenario planning](https://docs.fabricplan.com/planning-sheets/concepts/planning-tools/scenario-planning-in-microsoft-fabric.md) - [Forecasting](https://docs.fabricplan.com/planning-sheets/concepts/forecasting.md) - [Statistical forecasting algorithms using Predict](https://docs.fabricplan.com/planning-sheets/concepts/forecasting/predict-statistical-forecasting-algorithm.md) - [Reforecasting](https://docs.fabricplan.com/planning-sheets/concepts/forecasting/reforecasting.md) - [Closing forecast period](https://docs.fabricplan.com/planning-sheets/concepts/forecasting/closing-forecast-period.md) - [Collaboration and export - Writeback](https://docs.fabricplan.com/planning-sheets/concepts/writeback.md) - [Connected Planning](https://docs.fabricplan.com/planning-sheets/concepts/connected-planning.md) - [Connected planning with Infobridge in Fabric Planning](https://docs.fabricplan.com/planning-sheets/concepts/connected-planning/connected-planning.md) - [Blend measures](https://docs.fabricplan.com/planning-sheets/concepts/connected-planning/blend-measures.md) - [General](https://docs.fabricplan.com/planning-sheets/concepts/general.md) - [Top-down Planning](https://docs.fabricplan.com/planning-sheets/concepts/general/concepts.md) - [Bottom-up Planning](https://docs.fabricplan.com/planning-sheets/concepts/general/bottom-up-planning.md) - [How-tos](https://docs.fabricplan.com/planning-sheets/how-tos.md) - [Measure and row-based planning](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning.md) - [Insert data input columns](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns.md) - [Insert column - Fundamentals](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-fundamentals.md) - [Insert column - Number](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-manual-input-columns.md) - [Insert column - Text](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/text-checkbox-and-date.md) - [Insert column - Checkbox](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-checkbox.md) - [Insert column - Person](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/writeback-matrix-features.md) - [Insert column - List](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/dropdown.md) - [Insert column - Date](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-date.md) - [Insert column - Formula](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-calculated-columns.md) - [Insert column - Simulation](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/insert-manual-input-columns/insert-column-simulation.md) - [Measure-based modeling](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/measure-based-modelling.md) - [Cubes](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting.md) - [Plan across multiple dimensions with cubes](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/allocate-values-across-dimensions.md) - [Multidimensional expense allocation](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/multidimensional-expense-allocation.md) - [Multidimensional forecasting](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/multidimensional-forecasting.md) - [Cube best practices and FAQs](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/cube-best-practices-and-faqs.md) - [Manage cube measures](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/multidimensional-planning-and-forecasting/manage-cube-measures.md) - [Insert data input rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows.md) - [Insert rows - Fundamentals](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-manual-input-rows.md) - [Insert template rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/template-rows.md) - [Insert formula rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-calculated-rows.md) - [Insert blank rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-blank-rows.md) - [Insert forecast rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/insert-forecast-rows.md) - [Manage inserted rows](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/rows/manage-inserted-rows-and-columns.md) - [Row-based modeling](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling.md) - [Create a row model](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/create-a-row-model.md) - [Create forecasts using row model](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/create-forecasts-using-row-model.md) - [Perform scenario analysis in row model](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/perform-scenario-analysis-in-row-model.md) - [Configure row properties in a row model](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/configure-row-properties-in-the-model.md) - [Create row model templates](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/create-templates-for-reusable-row-structures.md) - [Tree view](https://docs.fabricplan.com/planning-sheets/how-tos/measure-and-row-based-planning/row-based-modeling/tree-view.md) - [Forecast data to predict future trends](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends.md) - [Create a P\&L forecast](https://docs.fabricplan.com/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/planning-sheets/how-tos/forecast-data-to-predict-future-trends/create-multi-dimensional-forecasts.md) - [Manage rolling forecasts](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/manage-rolling-forecasts.md) - [Generate Statistical Forecasts using PREDICT feature](https://docs.fabricplan.com/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/planning-sheets/how-tos/forecast-data-to-predict-future-trends/extend-planning-beyond-source-data-periods.md) - [Edit forecast settings](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/edit-forecast-settings.md) - [Allocate deficits to meet targets](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/allocate-deficits-to-meet-targets.md) - [Forecasting FAQ](https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends/forecasting-faq.md) - [Collabration and export](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export.md) - [Commenting and collaboration](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/commenting-and-collaboration.md) - [Export data](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/exports-in-the-planning-sheet.md) - [Persist data with Writeback](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback.md) - [Writeback in Plan](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/writeback-in-plan.md) - [General Settings](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/general-settings.md) - [Data Settings](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/data-settings.md) - [Destination Settings](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/destination-settings.md) - [Configure advanced settings](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/configure-advanced-settings.md) - [Configure writeback destinations](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/configure-writeback-destinations.md) - [View Logs](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/view-logs.md) - [Enable writeback in reading mode](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/enable-writeback-in-reading-mode.md) - [FAQs on Writeback](https://docs.fabricplan.com/planning-sheets/how-tos/collabration-and-export/persist-planning-data-using-writeback/faqs-on-writeback.md) - [Analyze planning outcomes with scenarios](https://docs.fabricplan.com/planning-sheets/how-tos/analyze-planning-outcomes-with-scenarios.md) - [Pivot data](https://docs.fabricplan.com/planning-sheets/how-tos/pivot.md) - [Format and display](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display.md) - [Layouts](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/layouts.md) - [Conditional formatting](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting.md) - [Create rules in Conditional Formatting](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting.md) - [Format by Rules (If conditions) in conditional formatting](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/format-by-rules-if-conditions-in-conditional-formatting.md) - [Page 1](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/page-1.md) - [Format by Color scale conditional formatting](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/format-by-color-scale-conditional-formatting.md) - [Format by classification conditional formatting](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/create-rules-in-conditional-formatting/format-by-classification-conditional-formatting.md) - [Quick formatting options](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/quick-formatting-options.md) - [Manage Rules](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/conditional-formatting/manage-rules.md) - [Add notes in a planning sheet](https://docs.fabricplan.com/planning-sheets/how-tos/format-and-display/notes-in-commenting-and-collaboration.md) - [Basic formatting](https://docs.fabricplan.com/planning-sheets/how-tos/basic-formatting.md) - [Number formatting](https://docs.fabricplan.com/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/planning-sheets/how-tos/basic-formatting/cell-header-and-value-formatting.md) - [Total and Subtotals](https://docs.fabricplan.com/planning-sheets/how-tos/basic-formatting/total-and-subtotals.md) - [Adding business logic and formulas](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae.md) - [Edit cells](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/editing-cells.md) - [Measures and Columns](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns.md) - [Importing data](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/importing-data.md) - [Invert sign](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/invert-sign.md) - [Pivot data](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/pivot-data.md) - [Optimize overview](https://docs.fabricplan.com/planning-sheets/how-tos/optimize-overview.md) - [Maximize or minimize a target value](https://docs.fabricplan.com/planning-sheets/how-tos/optimize-overview/maximize-or-minimize-a-target-value.md) - [Optimize input values to meet a target](https://docs.fabricplan.com/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/planning-sheets/how-tos/optimize-overview/use-optimize-on-derived-measures-and-allocation-rules.md) - [Configure approval workflows](https://docs.fabricplan.com/planning-sheets/how-tos/configure-approval-workflows.md) - [Connected planning](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge.md) - [Create a bridge to integrate and transform plans](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/1.-create-bridge.md) - [Blend measures by using Infobridge](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/blend-measures-by-using-infobridge.md) - [Import data into a bridge](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/2.-add-source-to-bridge.md) - [Manage query operations](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/4.-manage-queries.md) - [Manage sources](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/manage-sources.md) - [Share measures](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/share-measures.md) - [Consolidate data between sheets](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/import-measures-between-planning-sheets.md) - [Use dimension level](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/use-dimension-level.md) - [Data transformations](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations.md) - [Use pivot table](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/pivot-table.md) - [Group by transformations](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/group-by.md): Learn how to aggregate and summarize detailed reports with the Group by transformation. - [Add Column](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/add-column.md) - [Pivot and unpivot columns](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/pivot-columns-unpivot-columns.md) - [Rename column](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/rename-column.md) - [Use Find and Replace](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/find-and-replace.md) - [Remove column](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/remove-column.md) - [Filter rows](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/filter-rows.md) - [Sort](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/sort.md) - [Text functions](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/text-functions.md) - [Unnest](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/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/planning-sheets/how-tos/infobridge/data-transformations/round.md) - [Extract Comments](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/extract-comments.md) - [Import and export transformation steps](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/import-and-export.md) - [Query transformations](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/query-transformations.md) - [Append Queries](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/query-transformations/append.md) - [Join queries](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/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/planning-sheets/how-tos/infobridge/query-transformations/merge-queries.md) - [SQL queries](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/query-transformations/sql-queries.md) - [Duplicate a query](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/query-transformations/duplicate-a-query.md) - [Writeback transformed data from InfoBridge](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/writeback-transformed-data-from-infobridge.md) - [Manage security in planning](https://docs.fabricplan.com/planning-sheets/how-tos/manage-security-in-planning.md) - [Reference](https://docs.fabricplan.com/planning-sheets/reference.md) - [Formula syntax](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax.md) - [Conditional statements](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/conditional-statements.md) - [Logical functions](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/logical-functions.md) - [Math functions](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions.md) - [ABS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/abs.md) - [AVERAGE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/average.md) - [AVERAGEEXNEG](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/averageexneg.md) - [AVERAGEEXZERO](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/averageexzero.md) - [AVERAGEEXZERONEG](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/averageexzeroneg.md) - [CEILING](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/ceiling.md) - [COUNT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/count.md) - [DIVIDE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/divide.md) - [EVEN](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/even.md) - [EXP](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/exp.md) - [ODD](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/odd.md) - [FLOOR](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/floor.md) - [INDEXOF](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/indexof.md) - [LARGE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/large.md) - [LOG](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/log.md) - [MAX](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/max.md) - [MIN](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/min.md) - [MOD](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/mod.md) - [MROUND](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/mround.md) - [NUMBERVALUE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/numbervalue.md) - [PCT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/pct.md) - [POWER](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/power.md) - [PRODUCT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/product.md) - [RAND](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/rand.md) - [RANDBETWEEN](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/randbetween.md) - [ROUND](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/round.md) - [ROUNDDOWN](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/rounddown.md) - [ROUNDUP](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/roundup.md) - [SORT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/sort.md) - [SUBTRACT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/subtract.md) - [SUM](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/sum.md) - [SMALL](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/small.md) - [SQRT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/sqrt.md) - [PMT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/math-functions/pmt.md) - [Text formatting functions](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions.md) - [CONCATENATE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/concatenate.md): Joins multiple text strings into one single combined text value. - [CONCATALL](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/concatall.md) - [HYPERLINK](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/hyperlink.md) - [LEFT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/left.md) - [LOWER](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/lower.md) - [MID](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/mid.md) - [PROPER](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/proper.md) - [REPLACE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/replace.md) - [REPT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/rept.md) - [RIGHT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/right.md) - [TEXT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/text.md) - [TRIM](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/trim.md) - [UPPER](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/upper.md): Converts text to uppercase letters. - [VALUE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/text-formatting-functions/value.md) - [LEN](https://docs.fabricplan.com/planning-sheets/reference/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/planning-sheets/reference/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/planning-sheets/reference/formula-syntax/date-functions/dateadd.md) - [DATEDIFF](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/datediff.md) - [DAY](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/day.md) - [DATE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/date.md) - [DATE.FORMAT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/date.format.md) - [SOWEEK](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/soweek.md) - [SOMONTH](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/somonth.md) - [SOQTR](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/soqtr.md) - [SOYEAR](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/soyear.md) - [EOWEEK](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/eoweek.md) - [EOMONTH](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/eomonth.md) - [EOQTR](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/eoqtr.md) - [EOYEAR](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/eoyear.md) - [NETWORKDAYS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/networkdays.md) - [ADDDAYS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/adddays.md) - [ADDWEEKS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/addweeks.md) - [ADDMONTHS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/addmonths.md) - [ADDQTRS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/addqtrs.md) - [ADDYEARS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/addyears.md) - [FROM\_EXCELDATE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/fromexceldate.md) - [MONTH](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/month.md) - [DATE.NOW](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/now.md) - [PERIOD\_RANGE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/period_range.md) - [TO\_EXCELDATE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/toexceldate.md) - [YEAR](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/date-functions/year.md) - [Time intelligence functions](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/time-intelligence-functions.md) - [Relative time periods](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/time-intelligence-functions/relative-time-periods.md) - [Specific time periods](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/time-intelligence-functions/specific-time-periods.md) - [Period-to-date calculations](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/time-intelligence-functions/period-to-date-calculations.md) - [Time-based aggregations](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/time-intelligence-functions/time-based-aggregations.md) - [Time shifting and lookup](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/time-intelligence-functions/time-shifting-and-lookup.md) - [Other operators](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/other-operators.md) - [Identifiers](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/identifiers.md) - [Identifiers](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/identifiers/identifiers.md) - [Scripting functions](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions.md) - [DISPLAYTOAST](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/displaytoast.md) - [EXPORT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/export.md) - [LAYOUT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/layout.md) - [OPENKPIEXPLORER](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/openkpiexplorer.md) - [OPENMANAGECOLUMN](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/openmanagecolumn.md) - [OPENSEARCH](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/opensearch.md) - [OPENTOPN](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/opentopn.md) - [SENDMAIL](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/sendmail.md) - [SETCFRULE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setcfrule.md) - [SETCOLUMNSORT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setcolumnsort.md) - [SETFILTER](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setfilter.md) - [SETFILTERBYINDEX](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setfilterbyindex.md) - [SETFONTSIZE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setfontsize.md) - [SETFOOTER](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setfooter.md) - [SETHEADER](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setheader.md) - [SETLOCK](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setlock.md) - [SETMEASURETITLE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setmeasuretitle.md) - [SETMAXDECIMALPRECISION](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setmaxdecimalprecision.md) - [SETPAGINATION](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setpagination.md) - [SETSCALING](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setscaling.md) - [SETSEMANTICFORMATTING](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setsemanticformatting.md) - [SETSTATUSBAR](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setstatusbar.md) - [SETVALUE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setvalue.md) - [SETVISIBILITY](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/setvisibility.md) - [SHOWBETWEENPERIOD](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/showbetweenperiod.md) - [SHOWCLOSEDFORECAST](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/showclosedforecast.md) - [SHOWMEASUREBETWEENPERIOD](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/showmeasurebetweenperiod.md) - [TOPN](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/topn.md) - [DISPLAY SETTINGS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/display-settings.md) - [SETBLANKLABEL](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/setblanklabel.md) - [SETSUPPRESSZEROS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/setsuppresszeros.md) - [SETRAGGEDHIERARCHY](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/setraggedhierarchy.md) - [SEPARATOR](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/separator.md) - [SETCOMBINECOLUMNHEADER](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/setcombinecolumnheader.md) - [SEMANTICFORMAT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/semanticformat.md) - [SHOWNULLAS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/shownullas.md) - [SHOWZEROAS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/showzeroas.md) - [SINGLECHILD](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/scripting-functions/display-settings/singlechild.md) - [Statistical Functions](https://docs.fabricplan.com/planning-sheets/reference/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/planning-sheets/reference/formula-syntax/statistical-functions/calculate-measures-of-central-tendency.md) - [Calculate ranking and quartiles](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/statistical-functions/calculate-ranking-and-quartiles.md) - [Calculate variance and standard deviation](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/statistical-functions/calculate-variance-and-standard-deviation.md) - [Calculate percentiles and percent ranks](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/statistical-functions/calculate-percentiles-and-percent-ranks.md) - [Calculate normal distribution values](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/statistical-functions/calculate-normal-distribution-values.md) - [Miscellaneous functions](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/miscellaneous-functions.md) - [FETCH](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/miscellaneous-functions/fetch.md) - [LOOKUP](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/miscellaneous-functions/lookup.md) - [Measure/Column selection functions](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/measure-column-selection-functions.md) - [GETCOLBETWEENPERIODS](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/measure-column-selection-functions/getcolbetweenperiods.md) - [GETMEASURE](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/measure-column-selection-functions/getmeasure.md) - [SELECT](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/measure-column-selection-functions/select.md) - [SELECT\_BYINDEX](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/measure-column-selection-functions/select_byindex.md) - [Lookup functions - XLOOKUP](https://docs.fabricplan.com/planning-sheets/reference/formula-syntax/lookup-functions-xlookup.md): XLOOKUP is used for condition-based measure lookups. XLOOKUP finds rows that match one or more dimension conditions and returns the requested measure value. --- # 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/planning-sheets.md?ask=&goal= ``` `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.