Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Agg after recent date

Hi everyone,   I have this table below that is connect to a Calendar Table.   Date ID Column1 Column2 31/07/2021 A 160 1060 31/08/2021 A 200 1170 30/09/2021 A 175 1300 ...
Aggregation
dates
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 

    Please try

    Card1 =
    SUMX (
    VALUES ( 'Table'[ID] ),
    MAXX ( CALCULATETABLE ( TOPN ( 1, 'Table', 'Table'[Date] ) ), 'Table'[Column1] )
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 

Please try

Card1 =
SUMX (
VALUES ( 'Table'[ID] ),
MAXX ( CALCULATETABLE ( TOPN ( 1, 'Table', 'Table'[Date] ) ), 'Table'[Column1] )
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    tamerj1 thanks, it worked perfectly!