Latest datapoint before specific date.

[patrickbender]

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?

Date	Projectnumber	Margin
2017-12-28	123	3,2%
2017-11-23	123	3,0%
2017-09-15	123	3,1%

Year	Month
2017	11

[marcelviegas]

Hi,

min(aggr(

if(

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

attachment