Returns the conditional avg of a series of numbers

`AVGIF([Price] + ([Price] * [Tax Percent])/100, [Price] > 0)`

use this sampleReturns the conditional count of values

`COUNTIF_DISTINCT([ID], [Project] != 'OS')`

use this sampleReturns the difference between the specified start date and end date

`DATEDIFF([Created On], [Completed On], 'year')`

use this sampleReturns provided date part of date as a number

`DATEPART([Created On], 'year')`

use this sampleReturns the running difference for the given expression between current value and previous

`DIFFERENCE(SUM([Hours Spent]))`

use this sampleReturns the conditional max of a series of numbers

`MAXIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)`

use this sampleReturns the median of a series of numbers

`MEDIAN([Price] + ([Price] * [Tax Rate])/100)`

use this sampleReturns the conditional min of a series of numbers

`MINIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)`

use this sampleReturns the value at a given percentile of a dataset

`PERCENTILE([Price] + ([Price] * [Tax Rate])/100, 0.3)`

use this sampleReturns the running avg for a given expression from the first row to the current.

`RUNNING_AVG(SUM([Hours Spent]))`

use this sampleReturns the running max for a given expression from the first row to the current

`RUNNING_MAX(SUM([Hours Spent]))`

use this sampleReturns the running min for a given expression from the first row to the current

`RUNNING_MIN(SUM([Hours Spent]))`

use this sampleReturns the running sum for a given expression from the first row to the current

`RUNNING_SUM(SUM([Hours Spent]))`

use this sampleReturns the standard deviation of a series of numbers

`STDEV([Price] + ([Price] * [Tax Rate])/100)`

use this sampleReturns the conditional sum of a series of numbers

`SUMIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)`

use this sampleReturns the total for a given aggregation across the whole dataset

`TOTAL(SUM([Price]))`

use this sample