This content has been marked as final. Show 1 reply
In my dataset, I only have the start and end dates of the activities. Given that I cannot change the structure of the data, I'm just wondering if there is a way to achieve the result below:
|A||1 August 2017||31 August 2017|
|B||1 August 2017||30 September 2017|
|C||2 September 2017||20 October 2017|
|D||1 September 2017||30 November 2017|
To display activities that are active within month, for example, if I select September, it would display activity B, C & D; If I select October, if would display activity C & D.
I've tried to write calculations and use 1 and 0 to indicate whether the activity falls in a particular month, but the issue is I have many months in my data across different years (and I may also look at weeks instead of months), which means I have write a calculation for every single period which is not the most efficient way, given that the every day new data comes in.