7 Replies Latest reply: Mar 24, 2014 4:53 AM by Ashraf Muhammad Arsalan Ashraf RSS

    Interval match 2 dates and a range

    Michiel van de Goor

      I need to match the following:

       

      Date_from, Date_to, Start_amount, End_amount

      1-1-2013, 31-12-2013, 0, 500

      1-1-2013, 31-12-2013, 501, 1000

      1-1-2014, 31-12-2014, 0, 600

      1-1-2014, 31-12-2014, 601, 1100

       

      Fact:

      To a date and amount in my fact.

       

      The result should show in which category the line in my fact belong. This can be a combined field from Start_amount & End_amount.

      Result:

      Fact:

      24-2-2013, 700, 501-1000

      30-4-2014, 599, 0-600

      etc.

       

       

      is this even possible with interval match, 2 ranges?

       

      Thanks