Agg after recent date

Anonymous — Sun, 01 Jan 2023 19:47:02 GMT

Hi everyone,

I have this table below that is connect to a Calendar Table.

I want to calculate two metrics. They have to show the most recent result, that is defined by a slicer based on the Calendar Table. The metrics are:

I am struggling with getting the most recent result. Let's say that my slicer goes from 1/Jun/2021 to 15/Sep/2021 I want a card that shows me:

Any ideas on how to lock the most recent available value and then sum per ID? Thanks

Re: Agg after recent date

tamerj1 — Sun, 01 Jan 2023 20:38:09 GMT

Hi Anonymous

Please try

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

Anonymous — Sun, 01 Jan 2023 23:17:40 GMT

tamerj1 thanks, it worked perfectly!