Report tasks using start and/or end dates

[CD25]

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.

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[lbendlin]

Maybe surprisingly, Power BI does not support OR filters across columns. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com