sum of first min date

[Diana]

Dear ALL, I have an issue, please advice if you know the answer.

I am struggling to find  out the sum of first min date in my list:

It means that I need just 15 639 EUR.

The function that I use is:

=sum({<Date = {"$(=min(Date))", [Contract_ID]} >} [Lease Liability - opening])

, but it gives me (15 639+10 161) = 25 800, while I need just 15 639.

Please let me know which is the correct function to find it out.

Thank you.

Diana

[arulsettu]

Hi,

you have different values in the same min date. that is the reason you get the number. share the app to check 

maybe you have a filter to get the expected output

[shiveshsingh]

As you can also see in image, you have 2 values corresponding to single Date.

May be it is coming due to that, can you check in your model? 

[Shubham_Deshmukh]

Try this : 

MinString({<date={"=$(=min(date)"}>} [Lease Liability - opening])

[Diana]

thank you for suggestion

[Shubham_Deshmukh]

Diana, pls close the thread.