Filter Two Dates Columns with OR Condition

aquabirdakhal — Mon, 08 Apr 2024 17:29:40 GMT

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!

Re: Filter Two Dates Columns with OR Condition

lbendlin — Wed, 10 Apr 2024 00:36:05 GMT

see attached

topic Re: Filter Two Dates Columns with OR Condition in Custom Visuals Development Discussion

Filter Two Dates Columns with OR Condition

Re: Filter Two Dates Columns with OR Condition