Forum Discussion

Ssmit's avatar
Ssmit
Frequent Visitor
8 years ago
Solved

Filtering based on the earliest known activityTime date per ticket

Dear all, I'm trying to filter through tickets and I wanted to display the tickets where the activityTime is the earliest value and filter out everything else that has the same ticketNumber. ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI Ssmit

     

    Try this calculated Table

     

    New Table =
VAR tickets =
    SELECTCOLUMNS (
        VALUES ( Table1[ticketNumber] ),
        "Ticket_Number", [ticketNumber]
    )
RETURN
    GENERATE (
        tickets,
        CALCULATETABLE ( TOPN ( 1, Table1, Table1[activityTime], ASC ) )
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

HI Ssmit

 

Try this calculated Table

 

New Table =
VAR tickets =
    SELECTCOLUMNS (
        VALUES ( Table1[ticketNumber] ),
        "Ticket_Number", [ticketNumber]
    )
RETURN
    GENERATE (
        tickets,
        CALCULATETABLE ( TOPN ( 1, Table1, Table1[activityTime], ASC ) )
    )