• vilenvmo - Monday, February 26, 2018 5:23 AM

    Hi All

    I have a dateset for parameter that is filtered to only have the months where we have transactions or values for. In this case it is 3 months which will appear as multivalue drop down (Oct-17,Nov-17,Dec-17). i tried number of ways using combination of MDX and expressions to set the default as the Max or last date of the month. Which should be Dec 2017. How can I do this? Note the dataset was built using MDX designer

    Not sure exactly what you mean by "I have a dataset for parameter".   If you are using a dataset as a source for a parameter, that query would have to be able to be added with a maximum value specified, to the default value specification, based on what you're saying.   I think you need to determine that maximum value by in some way ranking all the supplied values and creating an additional column to hold that ranking value, and then use a pair of columns from that query, maybe...   Not sure it can be done without some form of hard coded value...

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)