Most Recent value (by date) in card

[ChrisElf]

Hello all,

I hope somebody can help me out with the following.

Im working with a Excels sheet that is updated weekly. How can I get a card to update to the most recent values automatically? For example:

Date	5 Week Moving Average	Weekly	Gold
11/Feb/21	90,04	139,60	1825,36
04/Feb/21	93,56	84,65	1792,26
28/Jan/21	95,70	103,29	1840,36
21/Jan/21	78,38	53,55	1869,91
14/Jan/21	72,56	69,09	1846,37
07/Jan/21	70,19	157,23	1912,5
31/Dec/20	55,55	95,31	1896,49
24/Dec/20	64,07	16,74	1876,56

I want to have the card to show the most recent (most recent date) of the 5 week moving average and the weekly.

Thanks for the help and effort!

Christian

[ChrisElf]

Thanks, @amitchandak much much appreciated!

[amitchandak · Accepted solution]

@ChrisElf , Try a measure like

new measure =
var _max = maxx(allselected(Table), Table[Date])
return
calculate(Average(Table[5 Week Moving Average]), filter(Table, Table[Date] = _max))