Laste date before date

[Jean_Pierre_Traets]

Dear @Pieter_Lesage, welcome to our community

I’m replying from my mobile device, therefore not able to give you a detailed solution.

Please check out this post, where a rather similar case is given support for.

SUMIf date is between [daterange controller]

I think this is what you were looking for For the Price Tasks.Filter([Done date]>=[daterangepicker 1].First() AND [Done date]<=[daterangepicker 1].Last() AND Epic.[Epic Name]=thisRow.[Epic Name]).Price.Sum() And for the Duration Tasks.Filter([Done date]>=[daterangepicker 1].First() AND [Done date]<=[daterangepicker 1].Last() AND Epic.[Epic Name]=thisRow.[Epic Name]).Worked.Sum() I don’t know why but I had to rewrite the formulas to get them to work.

Hopefully you will manage and if you can’t get it working, just let the community know