Hello,

I have a scorecard in performance point with data parameter Month-Year. We have data for few months only like March, Aug and Dec for 2014. On my date drop down parameters, we have last 12 months Month year list. Like May 2014-Apr 2015.  Now when user select June 2014, I need to display data for March 2014 as we dont have data for June 2014. If user selects march 2015, then we need to display Dec 2014 data as we have Dec 2014 data. How can I do that in Performance point? Do I have to write logic in KPI custom MDX or I  have to write logic in connection formula in performance point dashboard? what logic I need to write?

Thank you!