Microsoft Project MDX express using Time
-
Wednesday, 4 January 2012 1:24 PM
I am trying to build an MDX expression to calculate the Capacity Not Utilized (for work that has already been completed -history) and also calculate the Capacity Not Yeat Allocated ( to show capacity that is not being utilized in the future). The problem is I am trying to create a conditional value based on the time. I can capture the current Date using the Now() function, but how do I capture the date for the past and in the future conditionally in an iif() function. I know how to use [Time] in a Pivot Chart and I can see the year, quarter, month, week etc. So How does on get this date into a conditional statement that can be used in an MDX expresstion? Thanks in advance
exchange admin
