Functions

min(a,b)

The min() function returns the smallest numeric value of the input values.

max(a,b)

The max() function returns the largest numeric value of the input values.

abs(num)

The abs() function returns the absolute value of a number.

round(num)

The round() function rounds the number value up or down to the nearest integer.

rounddown(num)

The rounddown() function rounds numbers down to the nearest integer.

roundup(num)

The roundup() function rounds numbers up to the nearest integer.

if(condition, value_if_true, value_if_false)

The if() function allows you to create a conditional calculation, similar to what is available in Excel or Google Sheets.

if(condition, value_if_true, value_if_false)

Example to calculate gross profit margin:

if("Revenue"[0]=0,0,"Gross profit"[0]/"Revenue"[0])

If revenue is zero, display zero; otherwise, calculate the gross profit margin. This specific example prevents #ERRs from dividing by zero.

if_month(a, b)

The if_month function returns 1 if the time period is equal to the month number input in the formula, else 0.

• if_month(1) will return 1 if the month is January, else 0

• if_month(1, 6) will return 1 if the month is January or June, else 0

if_quarter_month(num)

The if_quarter_month function returns 1 if the time period is equal to the month number inside a given quarter. E.g., you can input [1;3] into the formula.

• if_quarter_month(1) returns 1 if the month is Jan, Apr, Jul, or Oct

• if_quarter_month(2) returns 1 if the month is Feb, May, Aug, or Nov

• if_quarter_month(3) returns 1 if the month is Mar, Jun, Sep, or Dec