In places the Excel function took a range (or a set of ranges,) the DAX function takes a column reference. For example, the function SUM doesn’t take a list of ranges in DAX it takes a column reference – and adds up the values in that column. In places where a function used to return the serial number representing a date, DAX will return the date itself using the date data type. Logical functions AND and OR only allow for two arguments in DAX. CONCATENATE has the same limitation. To get around this limitation, we recommend using the operators instead of these functions as shown here: AND && OR || CONCATENATE & Here are the Excel functions supported in DAX by Category: Date and Time ISNONTEXT COUNTBLANK DATE ISNUMBER MOD MAX DATEVALUE ISTEXT MROUND MAXA DAY PI MIN Logical EDATE POWER MINA AND EOMONTH QUOTIENT Text IF HOUR RAND CONCATENATE MINUTE IFERROR RANDBETWEEN EXACT NOT MONTH ROUND FIND OR NOW ROUNDDOWN FALSE SECOND ROUNDUP LEFT TRUE TIME SIGN LEN TIMEVALUE SQRT LOWER Math and Trig TODAY SUM MID ABS WEEKDAY SUMSQ REPLACE CEILING, WEEKNUM TRUNC REPT ISO.CEILING YEAR RIGHT EXP YEARFRAC SEARCH Statistical FACT SUBSTITUTE AVERAGE FLOOR Information TRIM AVERAGEA INT ISBLANK UPPER COUNT LN ISERROR COUNTA LOG ISLOGICAL
In places the Excel function took a range (or a set of ranges,) the DAX function takes a column reference. For example, the function SUM doesn’t take a list of ranges in DAX – it takes a column reference and adds up the values in that column. In places where a function used to return the serial number representing a date, DAX will return the date itself using the date data type. Logical functions AND and OR only allow for two arguments in DAX. CONCATENATE has the same limitation. To get around this limitation, we recommend using the operators instead of these functions as shown here: AND && OR || CONCATENATE & Here are the Excel functions supported in DAX by Category: Date and Time DATE DATEVALUE DAY EDATE EOMONTH HOUR MINUTE MONTH NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WEEKNUM YEAR YEARFRAC Information ISBLANK ISERROR ISLOGICAL ISNONTEXT ISNUMBER ISTEXT Logical AND IF IFERROR NOT OR FALSE TRUE Math and Trig ABS CEILING, ISO.CEILING EXP FACT FLOOR INT LN LOG MOD MROUND PI POWER QUOTIENT RAND RANDBETWEEN ROUND ROUNDDOWN ROUNDUP SIGN SQRT SUM SUMSQ TRUNC Statistical AVERAGE AVERAGEA COUNT COUNTA COUNTBLANK MAX MAXA MIN MINA Text CONCATENATE EXACT FIND LEFT LEN LOWER MID REPLACE REPT RIGHT SEARCH SUBSTITUTE TRIM UPPER
Data-Analysis-Expressions-in-PowerPivot-for-Excel-2010.docx