Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hello,
I tried this to do a test for today -365, but doesn't work:
Sum({<[Boekdatum] = {">=$(Today()-365)"}>}[Totaal bedrag €])
I also tried this.
hopefully someone can help?
sum({$<%key_kalender={'>=$(=AddMonths(Today(),-12))'}>}[Totaal bedrag €])
%key_kalender is the date field