Forum Discussion
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
- lbendlin
Super User
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
- Ashish_Mathur
Super User
Hi,
Share some data and show the expected result.