"syntax for '(' is incorrect" trying to use CALCULATE function in Excel 2010 RRS feed

  • Question

  • I am using PowerPivot 2012 for Excel version 11.1.3129.0 within Excel 2010 within my new job and am used to using it in newer versions of Excel.  

    I am getting an error using the CALCULATE function that just doesnt make sense to me.  No matter what I do I get the error below.  I have searched on the internet and all I have found thus far is "upgrade" however that is not an option for me.  Have others seen this?

    Thanks in advance for any help!

    Wednesday, May 15, 2019 4:01 PM