Forum Discussion

aquabirdakhal's avatar
aquabirdakhal
Regular Visitor
2 years ago

Filter Two Dates Columns with OR Condition

Hello Fabric Community,

I’m currently working on a Power BI report that involves a table (BAR) listing Application IDs, Submission Dates, and Completion Dates for the past 15 years (large dataset). Here’s an example of the data:

Application ID

Submission Date

Completion Date

149

3/1/2021

3/15/2021

156

3/19/2021

4/1/2021

211

4/21/2021

4/28/2021

232

4/30/2021

5/16/2021

255

6/7/2021

7/15/2021

303

9/18/2021

10/1/2021


My query also includes a 'Calendar' table.

I’d like to create a slicer that allows users to filter by a time range (e.g., from 4/1/2021 to 4/30/2021) to display all Application IDs that were either submitted or completed in the selected time frame.


Desired Visual after applying the filter for 4/1/2021 to 4/30/2021:

Application ID

Submission Date

Completion Date

156

3/19/2021

4/1/2021

211

4/21/2021

4/28/2021

232

4/30/2021

5/16/2021


I tried filtering after connecting the Calendar’s Dates to both BAR’s Submission and Completion dates but the results were not as expected:

Application ID

Submission Date

Completion Date

211

4/21/2021

4/28/2021

232

4/30/2021

5/16/2021


If anyone has insights on how to achieve the desired outcome, I’d greatly appreciate it!