Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago

Calculate last entry per Order

Hi all, ich have a sales table that shows multiple rows for each order since there are changes. Each change is recorded with a new version number: Order Nr Value Version 1 5 1...
Need Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi joshua1990 

please try

Sum of Last Version =
SUMX (
    VALUES ( 'Table'[Order Nr] ),
    CALCULATE ( MAXX ( TOPN ( 1, 'Table', 'Table'[Version] ), 'Table'[Value] ) )
)