none
DAX - Find first occurence of value in calculated column

    Question

  • Hello!

    I have a list of ID's that have duplicates.  I want to create a calculated column (Unique ID) that identifies the first occurence of each ID in the first column.  Below is an example of what it should look like in the end.

    What would the syntax be for the Unique ID calculated column??  I'm stumped.

     Table X

    ID

    Unique ID

    1

    1

    1

    0

    1

    0

    2

    1

    3

    1

    4

    1

    4

    0

    4

    0


    • Edited by undergrads1 Tuesday, November 19, 2013 4:53 PM
    Tuesday, November 19, 2013 4:47 PM

Answers

All replies