Reference for ingestia's analytical language (DAX-style, in Portuguese). There are 102 functions, with names in pt-BR and aliases in English. Each page is generated automatically from the product's function registry — if a function exists in the product, it's here, and vice versa (the docs and the product are kept in sync).
Brazilian syntax#
- Arguments are separated by
;(semicolon), not by a comma. - Decimal comma:
0,33. Thousands separator is a period:1.234,56. - Comparisons:
= <> > < >= <=. Text concatenation:&. - Variables:
VAR nome = expressão; RETORNAR expressão. - Dates use the America/Sao_Paulo time zone (
HOJE(),AGORA()).
About DAX compatibility#
The language is INSPIRED by DAX and keeps the English names as aliases, but it is NOT DAX. Where the semantics differ, the function's page explicitly marks it with DIFFERS from DAX. In general: aggregations and time intelligence operate on the VISUAL's rows (not on a tabular model with a marked date table), and an empty result is an honest blank, never a made-up zero.
Math (13)#
| Function | What it does | Aliases | DAX |
|---|---|---|---|
| ABS | Absolute value (no sign). | — | = DAX |
| ARRED | Rounds the number to N decimal places. | round | = DAX |
| TETO | Rounds up (integer). | ceiling, ceil | = DAX |
| PISO | Rounds down (integer). | floor | = DAX |
| POTENCIA | Base raised to the exponent. | power, pow | = DAX |
| RAIZ | Square root. | sqrt | = DAX |
| EXP | e raised to the number. | — | = DAX |
| LN | Natural logarithm. | — | = DAX |
| LOG | Logarithm in the given base (default 10). | — | = DAX |
| MOD | Remainder of the division. | — | = DAX |
| SINAL | -1, 0, or 1 depending on the sign. | sign | = DAX |
| INT | Integer part (rounds down). | — | = DAX |
| TRUNCAR | Cuts off the decimal places (doesn't round). | trunc | = DAX |
Statistics (10)#
| Function | What it does | Aliases | DAX |
|---|---|---|---|
| SOMA | Sums the column in the group. | sum | = DAX |
| MEDIA | Arithmetic mean of the column. | average, avg | = DAX |
| MEDIANA | Middle value (median). | median | = DAX |
| MIN | Smallest value in the column. | minimo | = DAX |
| MAX | Largest value in the column. | maximo | = DAX |
| CONT | Counts rows (or non-blank values in the column). | count | ≠ DAX |
| CONTD | Counts distinct values in the column. | distinctcount, countd | ≠ DAX |
| DESVPAD | Sample standard deviation. | stdev, stddev | = DAX |
| VAR | Sample variance. | variance | ≠ DAX |
| PERCENTIL | Percentile of the column (p between 0 and 1). | percentile | = DAX |
Logic (8)#
| Function | What it does | Aliases | DAX |
|---|---|---|---|
| SE | SE(condition; then; else?) — without the 'else' the result is blank. | if | = DAX |
| E | True when ALL conditions hold. | and | ≠ DAX |
| OU | True when ANY condition holds. | or | ≠ DAX |
| NAO | Negates the condition. | not | = DAX |
| SEERRO | Returns the fallback when the calculation errors (or comes out blank). | iferror | ≠ DAX |
| ESCOLHER | ESCOLHER(value; case1; res1; ...; default?) — also accepts the name CASO. | switch, caso | = DAX |
| COALESCE | 1st non-blank value in the list. | primeiro | = DAX |
| EHVAZIO | 1 when the value is blank. | isblank | = DAX |
Text (13)#
| Function | What it does | Aliases | DAX |
|---|---|---|---|
| CONCATENAR | Joins texts. | concatenate, concat | ≠ DAX |
| ESQUERDA | First N characters. | left | = DAX |
| DIREITA | Last N characters. | right | = DAX |
| EXTTEXTO | Part of the text starting at the position (1 = 1st character). | mid, substr | = DAX |
| NUMCARACT | Number of characters. | len, length | = DAX |
| MAIUSCULA | All uppercase. | upper | = DAX |
| MINUSCULA | All lowercase. | lower | = DAX |
| ARRUMAR | Removes extra spaces. | trim | = DAX |
| SUBSTITUIR | Replaces all occurrences of a substring. | substitute, replace | ≠ DAX |
| LOCALIZAR | Position of the substring within the text (0 = not found). | search, find | ≠ DAX |
| TEXTO | Number → text (pt-BR format). | format | ≠ DAX |
| VALOR | Text → number (accepts 1.234,56). | value | = DAX |
| SEQUENCIA | Series of numbers as TEXT (from; to; step?; separator?) — for card labels, legends, and subtitles. | generateseries, serie | ≠ DAX |
Date and time (32)#
| Function | What it does | Aliases | DAX |
|---|---|---|---|
| HOJE | Today's date. | today | ≠ DAX |
| AGORA | Current date and time. | now | ≠ DAX |
| ANO | Year of the date. | year | = DAX |
| MES | Month of the date (1 to 12). | month | = DAX |
| DIA | Day of the month. | day | = DAX |
| TRIMESTRE | Quarter (1 to 4). | quarter | = DAX |
| SEMANA | Week number in the year (the week starts on Sunday). | weeknum, week | = DAX |
| DIASEMANA | Day of the week (1 = Sunday … 7 = Saturday). | weekday, dayofweek | = DAX |
| DATADIF | Difference between two dates in the chosen unit. | datediff | ≠ DAX |
| FIMMES | Last day of the month, N months ahead. | eomonth | = DAX |
| EDATE | Same date N months ahead (or back). | datames | = DAX |
| DATA | Builds the date from year; month; day. | date | = DAX |
| ACUM_ANO | Year-to-date up to the current point (restarts at the beginning of the year of the model's calendar — January in the calendar year, April in an Apr–Mar fiscal year). | totalytd, ytd | ≠ DAX |
| ACUM_TRI | Quarter-to-date up to the current point. | totalqtd, qtd | ≠ DAX |
| ACUM_MES | Month-to-date up to the current point. | totalmtd, mtd | ≠ DAX |
| MESMO_PERIODO_ANO_ANTERIOR | The same date range, one year earlier. | sameperiodlastyear, spla | ≠ DAX |
| DESLOCAR_PERIODO | The same measure N periods before/after (unit: d, m, or a). | dateadd | ≠ DAX |
| MES_ANTERIOR | The measure over the ENTIRE PREVIOUS MONTH (not the group's range shifted). | previousmonth | ≠ DAX |
| ANO_ANTERIOR | The measure over the ENTIRE PREVIOUS YEAR (January 1 to December 31). | previousyear | ≠ DAX |
| TRIMESTRE_ANTERIOR | The measure over the ENTIRE PREVIOUS QUARTER. | previousquarter | ≠ DAX |
| PROXIMO_MES | The measure over the ENTIRE NEXT MONTH (useful for targets and forecasts already entered). | nextmonth | ≠ DAX |
| PROXIMO_ANO | The measure over the ENTIRE NEXT YEAR. | nextyear | ≠ DAX |
| PERIODO_PARALELO | The measure N periods back/ahead, always over the ENTIRE period (it's MES_ANTERIOR with the N you choose). | parallelperiod | ≠ DAX |
| DATAS_NO_PERIODO | Inside CALCULAR: a window of N periods from the given date (negative N goes back in time). It's the moving total — 3 months, 12 months, 7 days. | datesinperiod | ≠ DAX |
| SALDO_FINAL | The value on the LAST day WITH AN ENTRY in the period (not the sum). Period: "GRUPO" (default), "MES", "TRI", or "ANO". | closingbalance | ≠ DAX |
| SALDO_INICIAL | The value on the FIRST day WITH AN ENTRY in the period (not the sum). Period: "GRUPO" (default), "MES", "TRI", or "ANO". | openingbalance | ≠ DAX |
| PRIMEIRA_DATA | The earliest date in the current group. | firstdate | ≠ DAX |
| ULTIMA_DATA | The latest date in the current group. | lastdate | ≠ DAX |
| INICIO_MES | 1st day of the month (period, in the fiscal/4-4-5 calendar) of the current group. | startofmonth | ≠ DAX |
| FIM_MES | Last day of the month (period, in the fiscal/4-4-5 calendar) of the current group. | endofmonth | ≠ DAX |
| INICIO_ANO | 1st day of the year (fiscal, when configured) of the current group. | startofyear | ≠ DAX |
| FIM_ANO | Last day of the year (fiscal, when configured) of the current group. | endofyear | ≠ DAX |
Context and filter (26)#
| Function | What it does | Aliases | DAX |
|---|---|---|---|
| DIVIDIR | Error-free division: returns the fallback when the divisor is zero. | divide | = DAX |
| PCT_TOTAL | The group's share of the visual's total (0 to 1). | pcttotal | no eq. |
| ACUMULADO | Running sum up to the current point on the axis. | running | no eq. |
| SUMTOTAL | Grand total of the column across the whole visual. | — | no eq. |
| TUDO | Inside CALCULAR: ignores the group filter and uses the whole visual. | all | ≠ DAX |
| FILTRAR | Inside CALCULAR: keeps only the rows where the condition is true. | filter | ≠ DAX |
| TUDO_EXCETO | Inside CALCULAR: ignores the group filter BUT keeps the given column(s). | allexcept | = DAX |
| REMOVER_FILTROS | Inside CALCULAR: clears the group filter ONLY on the given column(s) and keeps the rest (it's the opposite of TUDO_EXCETO). | removefilters | = DAX |
| MANTER_FILTROS | Inside CALCULAR: makes the modifier ADD to the group filter instead of replacing it (the group still applies). With a simple condition it changes nothing — it already adds. | keepfilters | = DAX |
| TRATAR_COMO | Inside CALCULAR: uses the values the 2nd column has IN THE CURRENT GROUP as a filter on the 1st — links two columns with no declared relationship. Accepts up to 3 pairs. | treatas | ≠ DAX |
| ENTRE_DATAS | Inside CALCULAR: replaces the date filter with the given range (ignores the group's period). | datesbetween | = DAX |
| CALCULAR | Evaluates the expression with a changed filter: TUDO() ignores the group, FILTRAR() narrows it. | calculate | ≠ DAX |
| PRIMEIROS_N | Inside CALCULAR: keeps only the top N rows by the expression — or the top N groups, if you provide the column. A tie at the boundary is included in full (may exceed N). | topn | = DAX |
| CLASSIFICAR | Position of the current group among all the visual's groups by the measure (1 = highest). Ties share the same position. | rankx, ranquear | = DAX |
| PROCV | Value of a column in the row where the lookup matches (searches the whole visual). Accepts several lookup columns and a default at the end. | lookupvalue, procurar | = DAX |
| VALOR_SELECIONADO | The column's value when the group has only one; otherwise the given default. | selectedvalue | = DAX |
| TEM_UM_VALOR | 1 when the column has a single value in the current group. | hasonevalue | = DAX |
| ESTA_FILTRADO | 1 when the column is narrowed in the group (it has fewer values than in the whole visual). | isfiltered | ≠ DAX |
| SOMAX | Evaluates the expression for each row and SUMS the results. Accepts a FILTRAR(...) table as the 1st argument. | sumx | ≠ DAX |
| MEDIAX | Evaluates the expression for each row and takes the AVERAGE. Accepts a FILTRAR(...) table as the 1st argument. | averagex | ≠ DAX |
| MINX | Smallest result of the expression across the rows. Accepts a FILTRAR(...) table as the 1st argument. | — | ≠ DAX |
| MAXX | Largest result of the expression across the rows. Accepts a FILTRAR(...) table as the 1st argument. | — | ≠ DAX |
| CONTX | How many rows where the expression yields a value (non-blank). Accepts a FILTRAR(...) table as the 1st argument. | countx | ≠ DAX |
| JUNTARX | Joins the expression's result for each row into a single text. Accepts a FILTRAR(...) table as the 1st argument. | concatenatex | ≠ DAX |
| CAMINHO | Path from the root to the item in the parent-child hierarchy, separated by " | " (e.g., "3 | 3.1 |
| ITEM_CAMINHO | Level N of the path (1 = root). With "FIM" as the 3rd argument it counts backward (1 = the item itself). | pathitem | = DAX |
Reference generated automatically from the product's function registry and kept in sync with the formula engine.