Dax functions on PowerPivot - Regular excel functions in PowerPivot

I see that the "YEAR" function in Powerpivot is considered a DAX function.

Question:  Is any function used in a powerpivot a DAX function?
Related Question:  Is any formula created in  a PowerPivot called a Measure?

I'm kind of annoyed by all this word play by Microsoft.  I'm suffering from cell-related semantic seasickness.
There!  I just came up with my own specialized term!
Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
1. Yes. PowerPivot can only use DAX functions.
2. No. A measure is a data field based on a numeric calculation but you can also use formulas to create calculated columns.

See for example:

I'm not really sure what your gripe is - there is no word play here that I can see?
brothertruffle880Author Commented:
Hi Rorya!
You clarified my confusion with your explanation and links.

Many thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.