May be this:
Sum(Aggr(FirstSortedValue(Costs, -Date), Project))
UPDATE: Sample attached
253340.qvw 148.0 K
thank you for your kind answer. Your expression is really cool, it is actually good but it seems not to work in my own dashboard.
I am currently using this one:
this expression works fine as well, but I am not able to make it work for the previous year. Do you have any suggestion to make?