isfirtstoccurrence formula

DMManalili
DMManalili
in Modeling

Hi, question please. I need to get the first data(#1), hence I used the isfirstoccurrence but not sure on why the #2,#133 and #362 are also checked in the boolean? Thank you. 

 

DMManalili_0-1603458591412.png

 

Tagged:

Best Answers

  • anirudh
    anirudh
    Answer ✓

    Isfirstoccurrence should be used to get the first line of unique data and not the first line itself. To get the first data do this instead:
    CUMULATE(1, #Entry) = 1

    Regards,
    Anirudh

  • rob_marshall
    rob_marshall
    Answer ✓

    Along the same lines as what @anirudh was saying, use this formula:

     

    CUMULATE(1, FALSE, #Entry) = 1

     

    @anirudh missed the False

Answers

Categories