set analysis on date

[#1]

Lot's of threats about this subject on this forum. But still have not found it 😞

The case is simple

Transaction tables runs from 2005 until today

I want to be able to select on year and month in the calendar

Then the transaction table should only show transactions starting on the first day of that year until the last day of the selection.

Example selection: 2009 and March

Table should show all transactions from 1.1.2009 until 31.3.2009

Thanks for your support.

Johan.

[chriscammers · Accepted solution]

It should look something like this, the trick is to override the date selections on the calendar table and then select your date range

Sum({<[Year] = , [Month] = , [Quarter] = , [Date] = {"$(= '>=' & date(YearStart(Max ([Date]))) & '<=' & date(Max([Date])))"}

[#3]

In one go you got it right. That's amazing!

Thanks a lot, safes me a lot of time and frustrations 🙂