DAX Formatter now supports Power BI Desktop and Excel 2016 #dax #powerbi

If you use DAX, you should try DAX Formatter. Now it supports all the new functions introduced in Power BI Desktop and in Excel 2016.

There are more than 70 new functions, even if half of them corresponds to Excel functions with the same name (see the second group). DAX Formatter also supports the variable syntax available in the new DAX.

These are the new “original” DAX functions:

  • ADDMISSINGITEMS
  • CALENDAR
  • CALENDARAUTO
  • CONCATENATEX
  • CROSSFILTER
  • CURRENTGROUP
  • DATEDIFF
  • EXACT
  • EXCEPT
  • GEOMEAN
  • GEOMEANX
  • GETIMAGE
  • GROUPBY
  • IGNORE
  • INTERSECT
  • ISONORAFTER
  • KEYWORDMATCH
  • MEDIAN
  • MEDIANX
  • NATURALINNERJOIN
  • NATURALLEFTOUTERJOIN
  • PERCENTILE.EXC
  • PERCENTILE.INC
  • PERCENTILEX.EXC
  • PERCENTILEX.INC
  • PRODUCT
  • PRODUCTX
  • ROLLUPADDISSUBTOTAL
  • ROLLUPISSUBTOTAL
  • SELECTCOLUMNS
  • SUBSTITUTEWITHINDEX
  • SUMMARIZECOLUMNS
  • UNION
  • XIRR
  • XNPV

And this is the list of the functions identical to the Excel ones:

  • ACOS
  • ACOSH
  • ACOT
  • ACOTH
  • ASIN
  • ASINH
  • ATAN
  • ATANH
  • BETA.DIST
  • BETA.INV
  • CEILING
  • CHISQ.DIST
  • CHISQ.DIST.RT
  • CHISQ.INV
  • CHISQ.INV.RT
  • COMBIN
  • COMBINA
  • CONFIDENCE.NORM
  • CONFIDENCE.T
  • COS
  • COSH
  • COT
  • COTH
  • DEGREES
  • EVEN
  • EXPON.DIST
  • GCD
  • ISODD
  • ISEVEN
  • LCM
  • ODD
  • PERMUT
  • POISSON.DIST
  • RADIANS
  • SIN
  • SINH
  • SQRTPI
  • TAN
  • TANH