1 Reply Latest reply on Oct 2, 2012 5:35 AM by Martin Luxhøj

    Change measure when date is exceeded

    Martin Luxhøj

      Ok here goes:

       

      I'm showing a line of quantity over time (month) for a year. I'm trying to construct a calculation that will enable me to show order quantity when the maximum date of my data set is passed. In other words when there's no more actual data show order data from that date.

       

      Any help is much appriciated.

       

      //Martin

        • 1. Re: Change measure when date is exceeded
          Martin Luxhøj

          This is what I have now:

           

          CASE sum([NetTurnoverActual]) = 0

          WHEN TRUE THEN

          CASE [Choose Turnover]

          When 1 THEN sum([NetTurnoverActual]) + sum([NetTurnoverOrder])

          When 2 THEN sum([NetTurnoverActual]) + sum([NetTurnoverBudget])

          END

          WHEN FALSE THEN sum([NetTurnoverActual])

          END

           

          But when I ad a dimension to the color shelf the line is broken up by the meassures which I don't want.