Purchase Order, Line Number, Most Recent Revision Number Filter

[bhold32078]

I can usually scour the Google machine to find answers, but this one has me stumped... I'm not sure what to try next?

I need to filter the highest REVISIONNUM to each POLINENUM for all PONUM.

I'm trying to calculate total cost over a period of time and am getting duplicate SK_NS_MARKUPTOTAL additions, which makes the total costing much higher than reality.

I have tried the formula below with no success and both columns are Data Type: Whole Number

Table = POLINE

I only want the totals for REVISIONNUM "2" to be calculated in the above table.

Thanks for your help.

[amitchandak · Accepted solution]

I think you are not closing max at the correct place.  You need to have ), before allexpect.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601