Excel functions NOT available in PowerPivot

power pivot training courses

Excel Functions NOT available in PowerPivot

Functions that exist in Excel but are not available in PowerPivot include (we have only listed the ones we will miss). This is just for information purposes. You can skip this lesson if you want.

Date and time functions

  • NETWORKDAYS
  • WORKDAY

Information functions

  • ISERR
  • ISEVEN
  • ISNA
  • ISODD
  • ISREF
  • N
  • NA

Logical functions

All there but some only allow 2 options e.g. AND(logical1, logical2) or OR(logical1, logical2). As shown previously you can trick it into more by using && (for AND) and || (for OR)

Lookup and reference functions

  • CHOOSE
  • HLOOKUP
  • HYPERLINK
  • INDEX
  • INDIRECT
  • LOOKUP
  • MATCH
  • OFFSET
  • TRANSPOSE
  • VLOOKUP

Text functions

  • CLEAN
  • DOLLAR
  • PROPER
  • CODE

Financial functions

  • EFFECT
  • FV
  • IPMT
  • IRR
  • ISPMT
  • NOMINAL
  • NPER
  • NPV
  • PMT
  • PPMT
  • PV
  • RATE
  • XIRR
  • XNPV

Math and trigonometry functions

  • SUBTOTAL
  • SUMIF
  • SUMIFS
  • SUMPRODUCT

Statistical functions

  • AVERAGEIF
  • AVERAGEIFS
  • COUNTIF
  • COUNTIFS
  • LARGE
  • MEDIAN
  • MODE
  • RANK
  • SMALL

If you regularly use these functions in Excel you will need to find others ways to achieve the same thing in PowerPivot.

Lesson tags: powerpivot
Back to: PowerPivot Training Online > Calculations, calculated columns and relationships