Forum Discussion

spocx's avatar
spocx
Helper I
8 years ago
Solved

Finding first value with same ID in multiple rows based on date/time

Dear Power BI community   I need help to write a DAX formular that can identify the first value in multiple rows with the same ID based on date/time. I have a table as shown below and need to calcu...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi spocx,

     

    First Assign team =
VAR firstassigndate =
    CALCULATE (
        MIN ( 'table 1'[Assign date/time] ),
        ALLEXCEPT ( 'table 1', 'table 1'[Ticket ID] )
    )
RETURN
    CALCULATE (
        SELECTEDVALUE ( 'table 1'[Team assigned] ),
        FILTER (
            ALLEXCEPT ( 'table 1', 'table 1'[Ticket ID] ),
            'table 1'[Assign date/time] = firstassigndate
        )
    )

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello, I have a similar problem but in my case i need the distict count of the Id´s.

Because it has lines with the same id but diferent direction the dax calcuate count 2 times this id.

I want to make a dax that counts these tables and if it finds the repeated id counts only one.