I want to visualise data from 1 year based on selected dat

[thestaffsolutions]

Hello,

Our client has the following specific question:

I want to select a date and in a certain table, the expression should only show data from the selected dat -365 days.

So 365 days of data in total.

Per example:

The client selects 01/04/2022

Then the table should only show numbers from 01/04/2021 - 01/04/2022

The formula on wich this should be applied:

=Sum([Totaal bedrag €])

Thanks in advance!

[thestaffsolutions]

Hello,

I tried this to do a test for today -365, but doesn't work:

Sum({<[Boekdatum] = {">=$(Today()-365)"}>}[Totaal bedrag €])

[thestaffsolutions]

I also tried this.

hopefully someone can help?

sum({$<%key_kalender={'>=$(=AddMonths(Today(),-12))'}>}[Totaal bedrag €])

[thestaffsolutions]

%key_kalender is the date field