Excel formulas and corresponding Google Data Studio formulas.
Category Original Function Excel Formula Equivalent Looker Studio (Google Data Studio) Equivalent Notes Aggregation AVG(X) `AVERAGE(X)` `AVG(X)` Aggregation COUNT(X) `COUNT(X)` or `COUNTA(X)` `COUNT(X)` Excel: `COUNT` counts numbers, `COUNTA` counts non-blank cells. Aggregation COUNT_DISTINCT(X) `SUM(--(MATCH(UNIQUE(X),UNIQUE(X),0)=ROW(UNIQUE(X))-MIN(ROW(UNIQUE(X)))+1))` (Array formula for older Excel) or `COUNTA(UNIQUE(X))` `COUNT_DISTINCT(X)` Excel: `UNIQUE` function is available in newer Excel versions ...