Latest datapoint before specific date.

patrickbender — Mon, 30 Apr 2018 15:31:08 GMT

Hi,

I have the following table where i have a lot of data structured like below.

I also have an input field where I specify a year and a month.

I need to be able to find the latest margin before the end of the specified date.

With the below selection i would like to get the margin 3,0%.

If I instead change the month to 10 i would like to get 3,1.

I have experimented with:

FirstSortedValue([SP Marginal], [Målkortsdatum], n)

But this only gives me the nth latest margin.

Is there a way to do this?

Year	Month
2017	11

Re: Latest datapoint before specific date.

marcelviegas — Mon, 30 Apr 2018 18:04:39 GMT

Hi,

min(aggr(

if(

min({<date={">=$(filterDate)"}>}date)=date,Margin),date))

attachment