Is there a way to create an MDX Calculated Measure in Excel 2013 based on today's date.

In a normal Excel formula, I can have a calculation like:

=(now()-Start_Date)  / (End_Date - Start_Date)

I tried the following as an MDX Calculated Measure

([NOW]-[Plans].[Plan Start Date]) / ([Plans].[Plan End Date]-[Plans].[Plan Start Date])

and the result is #VALUE!

I am not even sure if this possible.  Any help would be appreciated.  Thanks.

Hi,

As far as I know, a Calculated Measure is a custom calculation that you can create in Excel when you are working with multidimensional data that is stored in SQL Server Analysis Services. Calculated Measures are useful for defining calculations that might not already exist in a database.

The syntax of Calculated Measure is different with a normal Excel formula. For more detail information, please refer to the following link:

https://support.office.com/en-ie/article/Calculated-items-in-Excel-and-Excel-Services-2d33ff89-38f7-4ed9-9386-7b7b4f3c151a

https://raphaelmsbithoughts.wordpress.com/2012/07/18/office-2013-new-olap-tools-part-1-calculated-measure/

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

Regards,

George Zhao
TechNet Community Support