5 Replies Latest reply on Feb 27, 2017 2:11 AM by lei.chen.0

    calculated field to remove duplicate date time values

    Mohit Shroff

      I have a table that has multiple values in a measure for the same date. For example:

      DATE               Output

      1/23 5AM          20

      1/23 8AM          30

      1/23 12 PM       23

      1/23 5 PM         12

      1/24 5AM          20

      1/24 8AM          54

      1/24 12 PM       23

      1/24 5 PM         47

      1/25 5AM          43

      1/25 8AM          98

      1/25 12 PM       52

      1/25 5 PM         60

       

      I want to make a calculated field that stores 1 output for each date before 9AM.