locked
How does EVALUATE function work in Power Pivot RRS feed

  • Question

  • Hello All, I am new to this forum and started playing with the Power pivot , DAX. While analyzing the DAX ,I came across a function EVALUATE , but when I tried this function in excel Power Pivot workbook - =EVALUATE 'Date'

    where 'Date' is my one of the Power pivot table , I was writing this function within the Calculation area of the Power Pivot model. 

    I get the below error when I hit enter after writing the function - 

    "The expression is not valid or appears to be incomplete.Please review and correct the expression.An MDX expression was expected while a full statement was specified."

    But in many forums I find the syntax is correct , could someone help me understand what I am doing wrong here ?

    Saturday, October 24, 2015 4:42 AM

Answers

  • Quote from the book
    "Microsoft Excel 2013: Building Models with PowerPivot"
    by Alberto Ferrari & Marco Russo
    Chapter 14 "Using DAX as a query language" page 418:
    "Your cannot use EVALUATE either in a calculated column or in a calculated field".
    EVALUATE generates an Excel Table.

    Saturday, October 24, 2015 10:20 PM
  • Quote from the book
    "Microsoft Excel 2013: Building Models with PowerPivot"
    by Alberto Ferrari & Marco Russo
    Chapter 14 "Using DAX as a query language" page 418:
    "Your cannot use EVALUATE either in a calculated column or in a calculated field".
    EVALUATE generates an Excel Table.

    Hi Jimmy,

    In addition to what Herbert has already mentioned, if you'd like to learn more about EVALUATE and how it can be used, please see the following links. Generally speaking, you'd only ever use EVALUATE when writing queries directly against the data model:

    Dynamic DAX Query Tables in Excel 2013

    Querying in DAX (Video)

    Querying in DAX (Power Point Slides)


    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    • Edited by Michael Amadi Sunday, October 25, 2015 6:26 PM
    • Proposed as answer by Charlie Liao Monday, October 26, 2015 5:55 AM
    • Marked as answer by Charlie Liao Wednesday, November 4, 2015 7:56 AM
    Sunday, October 25, 2015 8:23 AM

All replies

  • Can anyone be kind enough to reply to this thread or provide me a hint atleast ?
    Saturday, October 24, 2015 2:37 PM
  • Quote from the book
    "Microsoft Excel 2013: Building Models with PowerPivot"
    by Alberto Ferrari & Marco Russo
    Chapter 14 "Using DAX as a query language" page 418:
    "Your cannot use EVALUATE either in a calculated column or in a calculated field".
    EVALUATE generates an Excel Table.

    Saturday, October 24, 2015 10:20 PM
  • Quote from the book
    "Microsoft Excel 2013: Building Models with PowerPivot"
    by Alberto Ferrari & Marco Russo
    Chapter 14 "Using DAX as a query language" page 418:
    "Your cannot use EVALUATE either in a calculated column or in a calculated field".
    EVALUATE generates an Excel Table.

    Hi Jimmy,

    In addition to what Herbert has already mentioned, if you'd like to learn more about EVALUATE and how it can be used, please see the following links. Generally speaking, you'd only ever use EVALUATE when writing queries directly against the data model:

    Dynamic DAX Query Tables in Excel 2013

    Querying in DAX (Video)

    Querying in DAX (Power Point Slides)


    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    • Edited by Michael Amadi Sunday, October 25, 2015 6:26 PM
    • Proposed as answer by Charlie Liao Monday, October 26, 2015 5:55 AM
    • Marked as answer by Charlie Liao Wednesday, November 4, 2015 7:56 AM
    Sunday, October 25, 2015 8:23 AM