I’m hoping to add up the total sum of [Payment].Amount to [Invoices]
However, I want to filter by the date of the payment, so i am only calculating payments for this calendar year.
I think this might be possible already. But I can’t crack it.
Invoices.Sum( Payments.Filter([Payment Date] > 2020-01-01).Sum(Amount) )
Any ideas of how I can filter the Payments buy days after January 1st?