Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
aquabirdakhal
Regular Visitor

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!

1 REPLY 1
lbendlin
Super User
Super User

lbendlin_0-1712709325733.png

see attached

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors