Enterprise DNA

Dax Function Guide

Master the art of DAX with our expertly designed courses tailored to elevate your skills and knowledge.

Let’s create your free account

Google

Microsoft

If you have an account Login here

a b c d e f g h i j k l m n o p q r s t u v w x y z

AVERAGEX AVERAGEA AVERAGE ATANH ATAN ASINH ASIN APPROXIMATEDISTINCTCOUNT Function (DAX)AND Function (DAX)ALLSELECTED Function (DAX)ALLNOBLANKROW Function (DAX)ALLEXCEPT Function (DAX)ALLCROSSFILTERED Function (DAX)ALL Function (DAX)ADDMISSINGITEMS Function (DAX)ADDCOLUMNS Function (DAX)ACOSH Function (DAX)ACOS Function (DAX)ABS Function (DAX)

BLANK BETA.INV BETA.DIST

DIVIDE DISTINCTCOUNTNOBLANK DISTINCTCOUNT DISTINCT (table)DISTINCT (column)DEGREES DAY DATEVALUE DATESYTD DATESQTD DATESMTD DATESINPERIOD DATESBETWEEN DATEDIFF DATEADD DATE DATATABLE

EXPON.DIST EXP EXCEPT EXACT EVEN ERROR EOMONTH ENDOFYEAR ENDOFQUARTER ENDOFMONTH EDATE EARLIEST EARLIER

FORMAT FLOOR FIXED FIRSTNONBLANK FIRSTDATE FIND FILTERS FILTER FALSE FACT

GROUPBY GEOMEANX GEOMEAN GENERATESERIES GENERATEALL GENERATE GCD

HOUR HASONEVALUE HASONEFILTER

ISTEXT ISSELECTEDMEASURE ISONORAFTER ISO.CEILING ISNUMBER ISNONTEXT ISLOGICAL ISINSCOPE ISFILTERED ISEVEN ISERROR ISEMPTY ISCROSSFILTERED ISBLANK INTERSECT INT IN Operator / CONTAINSROW function IN IFERROR IF

KEEPFILTERS

LOWER LOOKUPVALUE LOG10 LOG LN LEN LEFT LCM LASTNONBLANK LASTDATE

MROUND MONTH MOD MINX MINUTE MINA MIN MID MEDIANX MEDIAN MAXX MAXA MAX

NOW NOT NORM.S.INV NORM.S.DIST NORM.INV NORM.DIST NEXTYEAR NEXTQUARTER NEXTMONTH NEXTDAY NATURALLEFTOUTERJOIN NATURALINNERJOIN

OR OPENINGBALANCEYEAR OPENINGBALANCEQUARTER OPENINGBALANCEMONTH ODD

PRODUCTX PRODUCT PREVIOUSYEAR PREVIOUSQUARTER PREVIOUSMONTH PREVIOUSDAY POWER POISSON.DIST PI PERCENTILEX.INC PERCENTILEX.EXC PERCENTILE.INC PERCENTILE.EXC PATHLENGTH PATHITEMREVERSE PATHITEM PATHCONTAINS PATH PARALLELPERIOD

QUOTIENT

ROW ROUNDUP ROUNDDOWN ROUND RIGHT REPT REPLACE REMOVEFILTERS RELATEDTABLE RELATED RANKX RANK.EQ RANDBETWEEN RAND RADIANS

TRUNC TRUE TRIM TREATAS TOTALYTD TOTALQTD TOTALMTD TOPN TODAY TIMEVALUE TIME TANH TAN T.INV.2t T.INV T.DIST.RT T.DIST.2T T.DIST

UTCTODAY UTCNOW USERNAME USERELATIONSHIP UPPER UNION UNICHAR

VARX.S VARX.P VAR.S VAR.P VAR VALUES VALUE

WEEKNUM WEEKDAY

XNPV XIRR

YEARFRAC YEAR

skills

tools

Create Your Personal Learning Plan

Learning Center

Learning Center

Project Center

Project Center

Guides

Guides

Analyst Hub

Community

Community

Enterprise DNA

Dax Function Guide

learning center

guide center

project center

tech

community

skills

tools