Forum Discussion

CD25's avatar
CD25
New Member
3 years ago

Report tasks using start and/or end dates

How can I create a report of events that start and/or end within a defined time period, e.g. next 30 days. Start dates and end dates are in separate columns.  Using a slicer, I can select starts by filtering using relative date, for example "Next 30 days". But when I use another slicer to select end dates in the same way, the result is "start AND end" when I want "start OR end" within the time period.  I am just learning DAX and believe that I need to create a separate column that indicates "True/False" for a time period.  However, I am open to learning.

2 Replies