Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
5 years ago

Count last Entry per Order

Hello! I have 2 tables: The first table (Sales Header) contains some basic information on order level. That means one row per order: Order-Nr Date Value 258 01.02.2021 50 938 13.12.2...
Need Help
jameszhang0805's avatar
jameszhang0805
Resolver IV
5 years ago

Please try:

VAR _max = CALCULATE( MAX( 'Table'[Step] ) , ALLEXCEPT( 'Table' , 'Table'[Order Nr] ) )
RETURN IF( MAX( 'Table'[Step] ) = _max , 1 )