Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
min(aggr(
if(
min({<date={">=$(filterDate)"}>}date)=date,Margin),date))
attachment