Excel functions NOT available in PowerPivot
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
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
Math and trigonometry functions
If you regularly use these functions in Excel you will need to find others ways to achieve the same thing in PowerPivot.