4 Replies Latest reply on May 4, 2018 12:42 PM by suvas.chandra

    Inception to Date from parameter selection

    suvas.chandra

      I have a parameter called Quarter End [2017 Q3, 2017 Q2, 2017 Q1.......................2008 Q1]. Users will select a date (in year quarter format) from the parameter and, it will return all the values based on selection.

       

      Parameter was created from this:

       

      Quarter 1 = STR(YEAR([QE Date]))+ " Q" + STR(DATEPART("quarter",[QE Date]))