12 Replies Latest reply on Oct 24, 2017 9:01 AM by Iestyn Humphreys

    First (beginning of period) and last (end of period) in any given period in a table

    Iestyn Humphreys

      I am trying to report in Gold.year.T.001 worksheet the value of the Gold LBMA measure at the beginning of each year that is 1 January and at the end of each year that is 31 December or the latest value in that specific year.

       

      Note that Date "dimension" is every day from 1 January 1900 to current day in 1 day increments.

       

      I am sure there is a calculation for this and is there one which generally works for the beginning and end of quarters or months on the same basis?

       

      Can anyone assist with this?

       

      Regards