The following DAX formula in invalid RRS feed

  • Question

  • Hi,

    In a certain workbook, when I write a calculated field formula as simple as =SUM(Purchases[Quantity]), I get a message saying that the "The following DAX formula is invalid".  This problem is happening only in this workbook.  In the same workbook, I can drag other DAX formulas to the PowerPivot without any problem.  All my slicers and CUBE formulas are working fine as well but I am not being able to write any new calculated field formula.

    This problem occurred only after latest Office and Windows updates were installed today.  I doubt this is an update related problem though because if that had been the case, then I would have been unable to write new calculated field in other workbooks.

    I am using Office 365 version 16.0.6741.2048

    Any help would be greatly appreciated.

    Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com

    Wednesday, June 15, 2016 5:12 AM


All replies