MDX measures calculated by its date value RRS feed

  • Question

  • Hi, I would like to now, how I can build query to show value which depends on the actual date.

    I have two lines of measures and I need to prepare third line to show a value from the previous ones based on the actual date. Expresion is like:

    iif([date].[hierarchy].currentmember>now(),[measures].[a], [measures].[b]

    Thank you in advance for your tips.


    • Changed type Jeff McCashland Friday, November 20, 2020 2:19 PM This is a question
    Friday, November 20, 2020 8:29 AM

All replies

  • Hi T,

    The purpose of this forum is to support the Open Specifications documentation. You can read about the Microsoft Open Specifications program at https://msdn.microsoft.com/en-us/openspecifications/default. The library of Open Specification documents is located at https://msdn.microsoft.com/library/dd208104.aspx.


    It doesn’t appear that you are implementing one of the protocols cited. if you are working with a specific on-the-wire Windows protocol please provide additional information regarding which protocol so that we can better understand how we can assist you.

    We suggest posting your question to the following forum, using the tag 'sql-server-transact-sql':

    sql-server-transact-sql - Microsoft Q&A

    Best regards,

    Jeff McCashland | Microsoft Protocols Open Specifications Team

    Friday, November 20, 2020 2:18 PM