Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a large amount of data, of which I draw a variety of charts from. The data has a date range of several years; and for some of the charts I would like to just report on certain years/months. Is there an expression I can add to my charts that would filter on year/month? If Start Date = xx/xx/15 effectively.
Part of my data table looks something like this:
Name | Start Date | End Date |
---|---|---|
JOB123 | 5/06/2013 | 5/06/2013 |
JOB123 | 11/06/2015 | 11/06/2015 |
Kind regards,
Tristan
If I understand you well, you might be able to use a set analysis like this:
{<[Start Date] = {"$(='>=' & Date(YearStart(Today()), 'M/DD/YYYY'))"}>}
See if this helps:
Best,
Sunny
Thanks very much Sunny; that's done it!
Best,
Tristan