IF Statement - Last Sequence number from Item ID

[howie2293]

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.

[mahoneypat · Accepted solution]

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