Forum Discussion

howie2293's avatar
howie2293
Frequent Visitor
5 years ago
Solved

IF Statement - Last Sequence number from Item ID

Trying to figure out identfifying the last sqeunce numebr that been genrated when the ID is the Same

Currenrtly have a table that has the following;

 

Item ID - Text 

Sqeunce ID - Auto generated Seqeunce Number

Task - Text

Date/Time - Date/Time

 

Wrapping my head around this currently as trying to figure get PowerBI to identify the last sequence number that refrence to ID based on that row.

 

 

Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Example/mock data would help give a more specific response, but please try a column expression like this one (replacing Table with your actual table name).

     

    Last Seq Number = CALCULATE(MAX(Table[Sequence ID]), ALLEXCEPT(Table, Table[Item ID]))

     

    Regards,

    Pat

     

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    Example/mock data would help give a more specific response, but please try a column expression like this one (replacing Table with your actual table name).

     

    Last Seq Number = CALCULATE(MAX(Table[Sequence ID]), ALLEXCEPT(Table, Table[Item ID]))

     

    Regards,

    Pat