> 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/reference.md).

# Reference

- [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/reference.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.